Introduction to DAX for Power BI Live Online 09:30 - 17:00 (UK Time) Oct 20, 2026

Course Syllabus

Module 1: Getting started with DAX

• 
  Introduction to DAX
• 
  Creating objects with DAX
• 
  Context and rules of evaluation
• 
  Variables, comments, and testing

Module 2: Performing basic calculations

• 
  Getting started
• 
  Implicit measures
• 
  Adding quick measures
• Working with DAX data types .
• 
  Doing basic math
• Using logic in your calculations
• 
  Using the if() function
• 
  Nested if()
• 
  Using the switch() function
• 
  Advanced switch()
• 
  Logical operators & functions: ||, OR(), &&, AND(), NOT()
• 
  Aggregating and summarizing data
• 
  The sum() function

Module 3: Working with context in the data model

• 
  Context defined
• 
  Data modeling basics
• 
  Introduction to dimensional modeling
• 
  Relationships and their effect on the evaluation context
• 
  Getting data from other tables using related() and related table
• 
  Looking up data without using relationships
• 
  Modifying the context using calculate()

Module 4: Performing more advanced calculations

• 
  The DAX iterator functions
• 
  Using table manipulation functions

Module 5: Working with time

• 
  Performing date calculations
• 
  Working with date tables
• 
  Generating a date table with the calendar() function
• 
  Defining custom operating periods
• 
  YTD, QTD, and MTD calculations
• 
  Custom to-date calculations
• 
  Finding year-over-year change
• 
  Finding moving averages

Module 6: Enhancing the user experience

• 
  Controlling visibility of your measures
• 
  Using what-if parameters
• 
  Adding banding
• 
  Using DAX to provide row-level security