Power BI – DAX Calculations and Measures

Unlock the power of DAX in Power BI to create dynamic calculations and gain deeper data insights.

Course overview

Duration: 1 day (6.5 hours)

This course is aimed at existing users who want to expand their skills to use DAX to create calculated columns and measures.

Participants should have either attended our Power BI – Introduction course or have equivalent knowledge. You should be able to import and transform data, create reports and build relationships between tables.

Participants MUST have the Power BI Application installed on their PC's to be able to attend the course.

Objectives

By the end of the course you will be able to:

Create calculated columns
Create date calculations
Create and use measures
Organise measures
Use the CALCULATE function
Use the FILTER function
Calculate period by period differences
Use the IF function and IS functions
Use the SWITCH function

Content

Creating Calculated Columns

Power Query custom columns vs DAX columns
Creating DAX calculated columns
Using Related

Working with Dates

Date calculations
Extracting date information

Creating Measures

Implicit vs Explicit Measures
Building measures
Using DAX
Common DAX functions
Using SELECTED VALUE

Organising Measures

Creating a measures table
Adding measures to a Measure table
Creating sub folders in a table

Using CALCULATE

Using the CALCULATE function
Adding the ALL context
Using the FILTER context

Time Intelligence Functions

Using the Quick measure
Calculating previous period
Period on period increases
% period on period increases
Using DIVIDE

Using IF and IS Functions

Using the IF function
Using IS functions
Using AND and OR

Using SWITCH

Using the SWITCH function

Discover more about our courses

Public Training Programme

Explore our current selection of public courses, available as convenient and cost-effective virtual sessions.

Engage with expert instructors and a diverse peer group in an interactive, online learning environment.

Ideal for those valuing flexibility and affordability, our public courses are ideal where you only have small numbers requiring training and offer training from the comfort of your home or office.

Check public dates

View our full catalogue of Leadership, Personal Development, Systems, Office Applications and Project Management courses

View our Leadership and Personal Development course catalogue

View our Systems and Office Applications course catalogue

View our Project Management course catalogue

Get in touch

Contact us

Do you have questions, suggestions, or feedback? We value your input and are here to assist you. Please don't hesitate to get in touch with us via email or phone:

Email: [email protected]
Phone: +44 (0)20 8152 6551

Our dedicated team is ready to respond to your enquiries and provide the support you need. Feel free to reach out, and we'll do our best to assist you.

Thank you for visiting our website, and we look forward to hearing from you!