Details

Goals

Creation of advanced measures in DAX.

Prerequisite

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

Contents

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 field,

  • 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).

Sign up

Next session(s)

Mon. 25 Nov.

Thu. 28 Nov.

Thu. 30 Jan.

Need a custom training?

None of the trainings fit your requirements? You have specific needs? Key Job trainers are versatile and flexible. Contact us!