Microsoft Power BI DAX Training Course
Learn how to write, manage and optimise DAX formulas for more powerful Power BI reports.
Learn how to write, manage and optimise DAX formulas for more powerful Power BI reports.
4.77
Build stronger DAX skills for Power BI reporting in one day.
Nexacu’s Power BI DAX course helps experienced Power BI users understand how DAX works and how to write more effective formulas, measures and expressions for business reporting.
This instructor-led course covers DAX functions, row context, filter context, time intelligence, table functions, practical calculations, DAX Studio, performance concepts and optimisation techniques.
Quick Answer
Power BI DAX is a one-day course for experienced Power BI users who want to improve their ability to write, manage and optimise DAX formulas. The course covers DAX functions, measures, row context, filter context, time intelligence, table functions, DAX Studio, performance concepts and optimisation. Strong Power BI Desktop skills, basic DAX and data modelling knowledge are recommended before attending.
Who should attend?
Experienced Power BI users, analysts, reporting teams, BI developers and data professionals who want to build stronger DAX calculation, modelling and optimisation skills.
What will you learn?
Learn how to write DAX functions, create complex measures, use row and filter context, apply time intelligence, work with table functions and improve DAX performance.
Prerequisite: Strong Power BI Desktop skills, basic DAX and data modelling knowledge are recommended. Completion of Power BI Advanced is recommended, and advanced Excel skills are preferred.
This course can also be taken as part of the PL-300 Power BI Certification pathway.
Power BI BeginnerLearn to use Power BI to create interactive dashboards, custom reports, analyse data and share insights.
Power BI IntermediateLearn to build data models and calculations to produce intelligent dashboards. In-class and remote training.
Power BI AdvancedAdvance your Power BI skills by learning DAX; Row Context, Functions, Calculated Columns, Measures and more.
Power BI Desktop Advanced ReportingMaster advanced Power BI reporting techniques in 1 day. Learn to create complex, layered, and interactive reports with custom visuals and navigation controls.
Power BI Data Transformation using Power QueryLearn Power Query for Excel and Power BI Desktop in 1 day. Master data transformation, query management, and M code to optimise your data workflows.
Data Visualisation with Power BI DesktopLearn to create powerful visualisations and reports in Power BI Desktop in 1 day. Master data modelling, visualisation techniques, and report sharing.
PL-300 Power BI Certification
Become a Microsoft Power BI certified expert. Attend our Nexacu Power BI courses, sit the PL-300 exam and become a Power BI Data Analyst Associate.
$2,170 inc GST
Course Introduction
What is DAX
DAX Functions
DAX Contexts
What is Vertipaq
DAX efficiency
DAX references
DAX best practices
Recap of Contexts
Introduction to Contexts
Recap of DAX Contexts
The Row Context
The Filter Context
Measures and Calculated Columns
Dataset for exercises – Computer Store sales
Filter and Row Context in a measure
The CALCULATE function
Context Transition
Filter Expressions of CALCULATE
Rules of Evaluation
CALCULATE and FILTER
Contexts in Calculated Columns
Introduction to Columns
Row Context in Calculated Columns
Filter Context in Calculated Columns
Relationships in Row Contexts
The RELATED function
The RELATEDTABLE function
Using RELATEDTABLE in a column
CALCULATED in row contexts
Row to Filter Context
Transformation Whiteboard
Exercise on row to filter contexts
Duplicates in the transformation
The LOOKUPVALUE function
Row Contexts in Measures
Introduction to Row Contexts
Row Contexts in Measures
Simple iterator in a measure
Row Context and a related table
Some more calculations exercise
Re-using measures
Implicit CALCULATE in a measure
An alternative approach using variables
Functions and FILTER
Introduction to DAX functions
Time Intelligence functions
Date (Dimension) tables
Using in-built TOTALYTD
Date modifier functions
Using date modifier DATESBETWEEN
Using date modifier DATESYTD
The magic behind Date Table functions
The case for simplicity – MAX or LASTDATE
Understanding the FILTER function
Contexts in the FILTER function
The filter context in functions
Naked column references
Simple filter expression
Comparing a value in the filter context
Adding another filter condition
The value of VALUES
Table Functions
Introduction to Table functions
Summarising tables
Using SUMMARIZE alone
The problem with SUMMARIZE
Using ADDCOLUMNS and SUMMARIZE
Using SUMMARIZECOLUMNS as a better alternative
A summary table in a measure
Practical DAX
Introduction to DAX calculations
Comparing functions – min/max and time intelligence
Debugging with DAX
Alternative patterns
The Quick Measure version
The KEEPFILTERS function
The TREATAS function
A few ORs or TREATAS
Using TREATAS and KEEPFILTERS
Using TREATAS for virtual relationships
DAX Tools
Use of third party tools
Introducing DAX Studio
What is DAX Studio
Download and Install DAX Studio
The DAX Studio Interface
How DAX Studio connects to the data
Viewing data model information
Creating a table query
Ordering a query result
A query returning a scalar
Defining a Measure
Declaring a variable
Incoming filter context
DAX Performance
Introduction to DAX Performance
The basics of the Vertipaq engine
Where is Vertipaq
A database of columns
Compression of a column
Identifying column compression
Understanding the TABLE_ID column
Power Query data statistics
Data Model Normalisation
Introduction to the Query Plan
Overview of the engines
The Formula Engine
The Storage Engine
Capturing a query
Special process to capture Power BI queries
Re-loading Power BI visuals
Understanding the query information from the capture
DAX Optimisation
Introduction to optimising DAX
Clear the Cache
Server Timings
Explaining the Server Timings
Steps to improve performance
Redefine a measure
The datacache
Optimisation by the Vertipaq engine
The CallBackDataID function
Reducing CallBackDataID instances
Optimising a Query in the Storage Engine
Viewing the Query Plan
Comparing two statistical functions
Extended Topics
Table Joins
Introduction to Table Joins
The Inner Join
A join on unrelated tables – TREATAS
The Outer Join
The Cross Join Using
GENERATE for Joins
Nested Row Context
Introduction to Nested Rows
How Nested Rows work
The EARLIER function
The EARLIEST function
Create a nested row in a column
How to avoid complex nesting expressions
Using variables to store values before nesting
Avoid iterators where possible
Further improve the efficiency of an expression
Ranking
Introduction to Ranking
Arguments in RANKX
Create a calculated column for ranking
Sort order of ranking
Definitions when ranking ties
Breaking Ties Manually
Creating a measure for ranking
Adjustments to make the RANKX measure work
What is DAX in Power BI?
DAX, or Data Analysis Expressions, is the formula language used in Power BI to create calculations, measures and analytical logic. It helps users build more powerful reports by defining how data is calculated, filtered and evaluated.
What will I learn in the Power BI DAX course?
You will learn how to write DAX functions, create measures, work with row context and filter context, use time intelligence functions, apply table functions, debug calculations, use DAX Studio and improve DAX performance.
Who should attend this Power BI DAX course?
This course is suitable for experienced Power BI users, analysts, reporting teams, BI developers and data professionals who want to improve their DAX calculation, modelling and optimisation skills.
Do I need Power BI experience before attending?
Yes. Strong Power BI Desktop skills, basic DAX and data modelling knowledge are recommended before attending. Completion of Power BI Advanced is recommended, and advanced Excel skills are preferred.
Is this course suitable after Power BI Advanced?
Yes. Power BI DAX is a suitable next step after Power BI Advanced for learners who want deeper skills in DAX formulas, measures, filter context, time intelligence and performance optimisation.
Does this course cover DAX measures?
Yes. The course covers how to define and reuse measures, create more complex expressions, use variables and understand how measures behave within row context and filter context.
Does this course cover time intelligence?
Yes. Participants learn time intelligence concepts including date dimension tables, TOTALYTD, date modifier functions, DATESBETWEEN, DATESYTD and related calculation patterns.
Does this course cover DAX Studio?
Yes. The course introduces DAX Studio, including how it connects to data, how to view data model information, create table queries, define measures, declare variables and analyse incoming filter context.
Will I learn how to optimise DAX performance?
Yes. The course covers DAX performance and optimisation concepts, including VertiPaq, storage and formula engines, query plans, server timings and techniques for improving inefficient expressions.
Can I take this Power BI DAX course online?
Yes. Nexacu offers this course as instructor-led live online training, with face-to-face options also available where scheduled. To attend remotely, select Remote East or Remote West as your location when booking.
What is remote Power BI training?
Remote Power BI training is delivered live online by an instructor. Participants can ask questions, join discussions, complete exercises and receive trainer support during the session.
Is Power BI DAX part of the PL-300 certification pathway?
Yes. Power BI DAX can be taken as part of Nexacu’s PL-300 Power BI Certification pathway, which is designed for learners who want to build a broader Power BI skill set.
What Power BI course should I take before Power BI DAX?
Power BI Advanced is recommended before attending Power BI DAX. Learners who are newer to Power BI should usually start with Power BI Beginner, then progress to Power BI Intermediate and Power BI Advanced before taking DAX.
Will I receive a certificate after completing this course?
Yes. Participants receive a certificate of completion, which can be added to a resumé or LinkedIn profile to acknowledge their Power BI DAX training.
Ready to build stronger DAX skills?
Choose an upcoming Power BI DAX course date and learn how to write, manage and optimise DAX formulas for more effective Power BI reports.
Power BI Training in Brisbane
View Dates
Power BI Training in Melbourne
View Dates
Power BI Training in Sydney
View Dates
Power BI Training in Adelaide
View Dates
Power BI Training in Perth
View Dates
Power BI Training in Canberra
View Dates
Power BI Training in Remote Online
View Dates Power BI BeginnerLearn to use Power BI to create interactive dashboards, custom reports, analyse data and share insights.
Power BI IntermediateLearn to build data models and calculations to produce intelligent dashboards. In-class and remote training.
Power BI AdvancedAdvance your Power BI skills by learning DAX; Row Context, Functions, Calculated Columns, Measures and more.
Power BI Desktop Advanced ReportingMaster advanced Power BI reporting techniques in 1 day. Learn to create complex, layered, and interactive reports with custom visuals and navigation controls.
Power BI Data Transformation using Power QueryLearn Power Query for Excel and Power BI Desktop in 1 day. Master data transformation, query management, and M code to optimise your data workflows.
Data Visualisation with Power BI DesktopLearn to create powerful visualisations and reports in Power BI Desktop in 1 day. Master data modelling, visualisation techniques, and report sharing.
PL-300 Power BI Certification
Become a Microsoft Power BI certified expert. Attend our Nexacu Power BI courses, sit the PL-300 exam and become a Power BI Data Analyst Associate.
$2,170 inc GST
Power BI Training in Brisbane
View Dates
Power BI Training in Melbourne
View Dates
Power BI Training in Sydney
View Dates
Power BI Training in Adelaide
View Dates
Power BI Training in Perth
View Dates
Power BI Training in Canberra
View Dates
Power BI Training in Remote Online
View Datesat Nexacu, we're proud to be the trusted training partner for hundreds of leading organisations accross Australia and New Zealand. From government departments to top corporates, we help teams upskill and succeed everyday
Students
4 & 5 Star Reviews
Google Reviews
Businesses Trust Nexacu
Custom workbook included with a step by step exercises
Resit your course for free within 6 Months
Valued by Individuals
