Power BI Desktop- DAX

Basic knowledge of Power BI Desktop (basic DAX and creating visuals).

This course enables you to create advanced measures in DAX within Power BI Desktop by mastering key functions such as CALCULATE, SUMX, RANKX, AVERAGEX, CONCATENATEX, and Time Intelligence functions like TOTALYTD and DATEADD. You will learn to manipulate filter contexts, apply filters on columns or tables (ALL, REMOVEFILTERS, FILTER), and build complex measures tailored to your analytical needs. Through a practical approach, you will develop concrete skills to enhance your reports and dashboards with powerful, dynamic indicators.

At the end of the course, participants will be able to:

• Create advanced measurements in DAX.

Reminders

• Create a calculated column
• Create a date table using a formula
• Create simple measures (SUM, DISTINCTCOUNT)
• Use CALCULATE to change the filter context within a formula

Function spotlight: Calculate

• Use CALCULATE with column filters
• Use CALCULATE with table filters (ALL, ALLSELECTED, REMOVEFILTERS, FILTER)

Iterator Functions

• Use SUMX to create a measure based on a calculation at table level (sum of field1*field2, etc.)
• Use CONCATENATEX and DISTINCT to create a measure that concatenates all possible values for a fiel
• Use RANKX to calculate Ranks
• Use AVERAGEX, SUMMARIZE and ADDCOLUMNS to create an average of sums by category

Time Intelligence

• Calculate Year-to-Date and Quarter-to-Date values (TOTALYTD, TOTALQTD)
• Compare a period to the same period one or more year(s), quarter(s) or month(s) earlier (DATEADD)
• Compare a period to its parent period – quarter to year, month to year, etc. (PARALLELPERIOD)