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 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.
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.
Introducing CALCULATE and CALCULATETABLE
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
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.