End User Applications Category Banner Image

Learn to Write DAX

  • Length 1 day
  • Price  NZD 750 exc GST
Course overview
View dates &
book now

Why study this course

Learn how to use Data Analysis Expressions (DAX) to create measures, calculated columns, tables, and queries to meet your reporting requirements.

Learning the DAX language allows you to create complex calculations in Power BI Desktop, Azure Analysis Services, SQL Server Analysis Services, and Power Pivot in Excel.

Request Course Information

What you’ll learn

After completing this course, students will be able to:

  • Understand the use of DAX in different applications

  • Choose appropriate functions for use in measures and columns

  • Use basic table functions

  • Understand evaluation contexts

  • Understand the CALCULATE function

  • Use variables for more user-friendly calculations

  • Work with iterators such as SUMX

  • Write time intelligence calculations

Microsoft Partner Cloud Logo

Microsoft Apps at Lumify Work

Lumify Work is your best choice for training and certification in any of Microsoft’s leading technologies and services. We’ve been delivering effective training across all Microsoft products for over 30 years, and are proud to be Australia's and New Zealand’s first and largest Microsoft Gold Learning Solutions Partner. Join more than 5,000 students who attend our quality Microsoft courses every year.

Who is the course for?

This course is intended for those who have completed some Power BI training and wish to learn how to use DAX for complex calculations.

Course subjects

Module 1: What is DAX?
This module introduces the use of DAX in different applications.

  • Understanding the data model

  • DAX for Excel users, SQL developers, MDX developers, and Power BI users

Module 2: Introducing DAX
This module introduces the components of a DAX formula and explains the different uses of measures and calculated columns.

  • Understanding DAX calculations

  • Understanding calculated columns and measures

  • Handling errors in DAX expressions

  • Using common DAX functions

Module 3: Using basic table functions
At the end of this module students will be able to write formulas which return a table as the result.

  • Understanding FILTER, ALL, and ALLEXCEPT

  • Understanding VALUES, DISTINCT

  • Using tables as scalar values

Module 4: Understanding evaluation contexts
Filter contexts are crucial to understanding what is happening in a DAX formula and ensuring you get the correct result.

  • Introducing filter and row contexts

  • Using the row context with iterators

  • Understanding FILTER, ALL, and context interactions

Module 5: Understanding CALCULATE
CALCULATE is perhaps the most important function in DAX, allowing you to work with evaluation contexts appropriately.


  • Understanding context transition

  • CALCULATE rules

Module 6: Variables
Learn how to use variables to simplify your DAX formulas.

  • Introducing VAR syntax

  • Understanding the scope of variables

  • Common patterns using variables

Module 7: Working with iterators and CALCULATE
Use iterators such as SUMX to meet common reporting needs.

  • Using iterators

  • Solving common scenarios with iterators

Module 8: Time Intelligence calculations
Understand how to work with dates to write useful time intelligence calculations such as Year to Date and Year Over Year Change.

  • Building a date table

  • Using year-to-date, quarter-to-date, and month-to-date

  • Computing a difference over previous periods

  • Computing a moving annual total


Before attending this course, students must have: 

  • Attended Microsoft PL-300T00 Power BI Data Analyst or possess equivalent knowledge and skills

  • Knowledge of relational databases and reporting

  • Some basic knowledge of data warehouse schema topology (including star and snowflake schemas)

  • Some exposure to basic programming constructs (such as looping and branching)

  • Familiarity with Microsoft Office applications, particularly Excel

An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.

Terms & Conditions

The supply of this course by Lumify Work is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.

Request Course Information

Personalise your schedule with Lumify USchedule

Interested in a course that we have not yet scheduled? Get in touch, and ask for your preferred date and time. We can work together to make it happen.