Duration: 1 day

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.

 

 

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

 

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

  • Date calculations
  • DATEDIFF
  • Extracting date information

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

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

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

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

  • Using the IF function
  • Using IS functions
  • Using AND and OR

  • Using the SWITCH function
need something bespoke? get in touch


Back to all courses