Description
Description
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.
Objectives
At the end of the course, participants will be able to:
Create advanced measurements in DAX.
Program
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)
Prérequisites
Basic knowledge of Power BI Desktop (basic DAX and creating visuals).
Conditions
Course Material
The training material will be handed out at the beginning of the course.
Location
L-1611 Luxembourg
Luxembourg
Sessions and schedules
Would you like to stay up to date on our training offer?
Subscribe to our newsletter