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)

Thu. 30 Jan.

Thu. 06 Feb.

Fri. 21 Feb.

Wed. 12 Mar.

Tue. 29 Apr.

Mon. 26 May.

Thu. 05 Jun.

Thu. 19 Jun.

Need a custom training?

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