Microsoft Power BI DAX Training Course
Learn the fundamentals of DAX on our One-Day Course - login from home
Learn the fundamentals of DAX on our One-Day Course - login from home
4.77
All courses available in-class or remotely.
To attend remotely, select "Remote East" or "Remote West" as your location on book now.
Power BI is a powerful tool, and in order to take your modeling ability to the next level it's essential to have a solid understanding of the DAX language. While it's possible to achieve a lot without DAX knowledge, delving into this language will unlock a whole new level of capabilities and insights. Our comprehensive one-day course builds on the knowledge our students have already learnt through the beginner, intermediate, and advanced Power Bi courses, and introduces key concepts of DAX as well as guiding them through practical exercises on how to write DAX formulas. You will learn:
Strong Power BI Desktop skills, basic DAX and data modelling knowledge, with Power BI Advanced course completion recommended. Advanced Excel skills preferred.
Take this course as part of the PL-300 Power BI Certification and save:
PL-300 Power BI Certification
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 Power BI?
Power BI is Microsoft’s business intelligence and data visualisation platform. It helps users connect to data, clean and transform datasets, build reports, create dashboards and share insights across an organisation.
What Power BI courses does Nexacu offer?
Nexacu offers Power BI Beginner, Power BI Intermediate, Power BI Advanced, Power BI DAX, Data Transformation with Power Query, Power BI Desktop Advanced Reporting, Data Visualisation with Power BI Desktop and PL-300 Power BI Certification.
Which Power BI course should I start with?
If you are new to Power BI, start with Power BI Beginner. If you already understand the basics, Power BI Intermediate is a suitable next step. More experienced users may choose Power BI Advanced, Power BI DAX, Data Transformation with Power Query or Power BI Desktop Advanced Reporting, depending on their goals.
Are Power BI courses suitable for beginners?
Yes. Power BI Beginner is designed for people who are new to Power BI and want to learn how to create reports, dashboards and visualisations. Basic confidence working with data, especially in Excel, is helpful.
What will I learn in Power BI training?
Depending on the course level, you may learn how to connect to data, transform data with Power Query, create data models, build visualisations, design dashboards, write DAX measures, manage filters, publish reports and share insights through the Power BI service.
Is Power BI training relevant for workplace reporting?
Yes. Nexacu’s Power BI courses are designed around practical workplace reporting and business intelligence tasks, including interactive dashboards, data models, automated reporting, DAX calculations, Power Query transformations and shared reports.
How difficult is Power BI to learn?
Power BI is accessible for beginners, but the difficulty depends on your experience with data, Excel, reporting and business intelligence concepts. Most learners start with the basics, then progress into data modelling, Power Query, DAX and advanced reporting as their needs grow.
Do I need Excel experience before learning Power BI?
Excel experience is helpful, especially if you work with spreadsheets, tables, PivotTables, charts or business data. It is not always required, but basic data confidence will help you get more from Power BI training.
Does Power BI training include DAX?
Yes. DAX is introduced in some Power BI courses and covered in more depth in Power BI Advanced and Power BI DAX. Learners who need stronger calculation, measure and modelling skills should consider the dedicated Power BI DAX course.
Does Power BI training include Power Query?
Yes. Power Query is included in relevant Power BI courses and covered in detail in Data Transformation with Power Query. This course is useful for learners who need to clean, reshape, combine and prepare data before reporting.
Can I attend Power BI training online?
Yes. Nexacu offers live online Power BI training through Remote East and Remote West sessions. Remote courses are instructor-led, so participants can ask questions, join discussions, complete exercises and receive trainer support during the class.
Where are face-to-face Power BI courses available?
Nexacu offers face-to-face Power BI courses in major Australian cities where scheduled, including Sydney, Melbourne, Brisbane, Canberra, Adelaide and Perth. Live online attendance is also available for remote learners.
Is Power BI training available for corporate teams?
Yes. Nexacu provides Power BI corporate training for teams and organisations that need consistent skills in reporting, dashboards, data modelling, DAX, Power Query and business intelligence workflows.
Is PL-300 Power BI Certification available?
Yes. Nexacu offers PL-300 Power BI Certification as part of its Power BI course pathway. This pathway is suitable for learners who want to develop broader Power BI capability and prepare for Microsoft Power BI certification.
How many students are typically in a Power BI course?
Class sizes vary by session, but Nexacu generally keeps Power BI classes small so participants can ask questions, take part in discussion and receive trainer support throughout the course.
Will I receive a certificate after completing Power BI training?
Yes. Participants receive a certificate of completion, which can be added to a resumé or LinkedIn profile to acknowledge their Power BI training.
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 across 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
Learn with expert instructors, wherever you are
Valued by Individuals
