Courses
Mastering DAX
Length: 2 Days
Cost: $1,395 + GST
Version: Power BI

= Scheduled class

= Guaranteed to run

= Fully booked
Click on the dates to book online
Centre | Mar | Apr | May | Jun |
---|
Auckland | -- | 19 | -- | -- |
Hamilton | -- | -- | 17 | -- |
Christchurch | -- | 29 | -- | -- |
Wellington | -- | 06 | 31 | -- |
Virtual Class | -- | -- | -- | -- |
Can't find a class in your area? Contact our sales team and request a class date.
Not sure about the version of your software? Click here to find out.
Want to know if this course is right for you? Assess your skills level with our online Skills Assessment tool.
About this Course
The goal of the course is to demonstrate all the features of DAX, providing the knowledge to write formulas for common and advanced business scenarios. Students will use DAX to solve real world scenarios that enhance reporting capabilities.
While DAX can be used across a variety of applications, this course will be taught using Power BI.
Audience
Have you been using DAX for a while? Are you drowning in Youtube videos? Tired of copying DAX expressions that you don’t understand? This training is aimed at Power BI, Power Pivot for Excel and Analysis Services developers who wish to gain a better understanding of DAX and the context behind it. Discover some of the lesser-known DAX functions, explore the different behaviours of similar functions (and discuss when to use each) and master your understanding of CALCULATE.
Prerequisites
Before attending this course you must:
- have experience with Power BI equivalent to that covered in Power BI Essential Skills
- understand reporting data models in Power BI, Excel PowerPivot or SSASS Tabular Model
- have a basic understanding of DAX functions and syntax (ie able to use SUM, CALCULATE, or IF functions to create calculated columns and measures)
At Course Completion
Upon completion of this course, students will:
- Create complex calculated measures to further extend the reporting capabilities of the Power BI data model
- Understand the context of the DAX language and how it works within the report’s data model
- Demonstrate proper use of the CALCULATE function and how it behaves
- Use table functions to dynamically filter measures
- Understand the properties of a Date table and use it to create time intelligence measures
- Know what to look out for when using DAX in reporting
Course Outline
Module 1: Introduction to DAX
- What is DAX?
- DAX data types
- Calculated columns
- Measures
- Naming conventions
- Measures vs Calculated Columns
- Handling errors
- Aggregation Functions
- Counting Values
- Logical Functions
- The SWITCH Function
- Information Functions
- MAX and MIN Functions
- Mathematical Functions
- DIVIDE Function
- Using Variables
- Rounding, Text, and Date Functions
- Relational Functions
Module 2: Table Functions
- Introduction to Table Functions
- FILTER Function
- ALL Function
- ALLEXCEPT Function
- Mixing Filters
- DISTINCT Function
- VALUES and ALLNOBLANKROW Functions
- ISEMPTY Function
- RELATEDTABLE Function
- Tables and relationships
- Calculated Tables
Module 3: Evaluation Contexts
- Introduction to evaluation contexts
- Filter Context
- Row Context
- There are always two contexts
- Context errors
- Working with evaluation contexts
- EARLIER in nested row contexts
- EARLIER and variables
Module 4: CALCULATE Function
- Introduction to CALCULATE
- CALCULATE examples
- Filters are Tables
- OR conditions in CALCULATE
- Clear filter on one column only
- CALCULATE Tasks
- Ratios and Percentages
- Variables and evaluation contexts
Module 5: Evaluation contexts and Relationships
- Introduction to evaluation contexts and relationships
- Row context and relationships
- Filter context and relationships
- CALCULATE examples
- Filtering many columns
- Filter arguments in CALCULATE
- FILTER and CROSSFILTER Functions
- HASONEVALUE Function
- ALLSELECTED Function
- Context transition
- Automatic CALCULATE in measures
- Equivalent Filter context
- Circular dependency
Module 6: Building a Date Table
- Introduction
- CALENDAR Function
- CALENDARAUTO Function
- Mark as Date Table
- Set sorting options
- Multiple dates
Module 7: Working with Iterators
- Introduction to Iterators
- Useful iterators
- MIN-MAX sales per customer
- Statistical and Financial Functions
- RANKX Function
Module 8: Time Intelligence DAX
- Introduction to Time Intelligence
- Aggregations over time
- Year to Date Functions
- Previous year and DATEADD Functions
- PARALLELPERIOD Function
- Running Total
- Moving Annual Total
- Semi-additive Measures
- Calculations over weeks
Print this page