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:

  • To write DAX functions and understand expressions
  • Use tools to help manage and create DAX
  • Create complex expressions
  • Learn methods to optimise expressions and more.

Prerequisite:

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

Course Details

Download Course PDF
Price
$595 $660
Duration
1 day
Times
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online

Course Details

Download Course PDF
Price
$595 $660
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 8
201 Charlotte Street
Brisbane QLD 4000

Course Details

Download Course PDF
Price
$595 $660
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 24/477 Pitt Street
Sydney
New South Wales 2000

Course Details

Download Course PDF
Price
$595 $660
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 12A
45 William Street Melbourne VIC 3000

Course Details

Download Course PDF
Price
$595 $660
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
NEW LOCATION
Level 2
221 London Circuit
Canberra ACT 2600

Course Details

Download Course PDF
Price
$595 $660
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 15
33 King William Street
Adelaide 5000

Course Details

Download Course PDF
Price
$595 $660
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 7
553 Hay Street
Perth WA 6000

Course Details

Download Course PDF
Price
$595 $660
Duration
1 day
Times
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online

Upcoming Courses

Remote East

Brisbane

Sydney

Melbourne

Canberra

Adelaide

Perth

Remote West

Remote East
Date
Course
City
Status
Tue 26 Aug 25
Tue
26
Aug
Power BI DAX
Remote East
Status: Confirmed
Confirmed
Mon 15 Sep 25
Mon
15
Sep
Power BI DAX
Remote East
Status: Confirmed
Confirmed
Wed 29 Oct 25
Wed
29
Oct
Power BI DAX
Remote East
Status: Confirmed
Confirmed
Mon 10 Nov 25
Mon
10
Nov
Power BI DAX
Remote East
Status: Confirmed
Confirmed
Wed 19 Nov 25
Wed
19
Nov
Power BI DAX
Remote East
Status: Scheduled
Scheduled
Wed 10 Dec 25
Wed
10
Dec
Power BI DAX
Remote East
Status: Confirmed
Confirmed
Brisbane
Date
Course
City
Status
Mon 15 Sep 25
Mon
15
Sep
Power BI DAX
Brisbane
Status: Scheduled
Scheduled
Mon 10 Nov 25
Mon
10
Nov
Power BI DAX
Brisbane
Status: Scheduled
Scheduled
Wed 10 Dec 25
Wed
10
Dec
Power BI DAX
Brisbane
Status: Scheduled
Scheduled
Sydney
Date
Course
City
Status
Mon 15 Sep 25
Mon
15
Sep
Power BI DAX
Sydney
Status: Scheduled
Scheduled
Wed 29 Oct 25
Wed
29
Oct
Power BI DAX
Sydney
Status: Scheduled
Scheduled
Mon 10 Nov 25
Mon
10
Nov
Power BI DAX
Sydney
Status: Scheduled
Scheduled
Wed 19 Nov 25
Wed
19
Nov
Power BI DAX
Sydney
Status: Scheduled
Scheduled
Wed 10 Dec 25
Wed
10
Dec
Power BI DAX
Sydney
Status: Scheduled
Scheduled
Melbourne
Date
Course
City
Status
Tue 26 Aug 25
Tue
26
Aug
Power BI DAX
Melbourne
Status: Confirmed
Confirmed
Mon 15 Sep 25
Mon
15
Sep
Power BI DAX
Melbourne
Status: Scheduled
Scheduled
Wed 29 Oct 25
Wed
29
Oct
Power BI DAX
Melbourne
Status: Scheduled
Scheduled
Mon 10 Nov 25
Mon
10
Nov
Power BI DAX
Melbourne
Status: Scheduled
Scheduled
Wed 10 Dec 25
Wed
10
Dec
Power BI DAX
Melbourne
Status: Scheduled
Scheduled
Canberra
Date
Course
City
Status
Mon 15 Sep 25
Mon
15
Sep
Power BI DAX
Canberra
Status: Scheduled
Scheduled
Mon 10 Nov 25
Mon
10
Nov
Power BI DAX
Canberra
Status: Confirmed
Confirmed
Wed 10 Dec 25
Wed
10
Dec
Power BI DAX
Canberra
Status: Scheduled
Scheduled
Adelaide
Date
Course
City
Status
Mon 15 Sep 25
Mon
15
Sep
Power BI DAX
Adelaide
Status: Scheduled
Scheduled
Mon 10 Nov 25
Mon
10
Nov
Power BI DAX
Adelaide
Status: Scheduled
Scheduled
Wed 10 Dec 25
Wed
10
Dec
Power BI DAX
Adelaide
Status: Scheduled
Scheduled
Perth
Date
Course
City
Status
Fri 22 Aug 25
Fri
22
Aug
Power BI DAX
Perth
Status: Confirmed
Confirmed
Mon 8 Sep 25
Mon
8
Sep
Power BI DAX
Perth
Status: Scheduled
Scheduled
Mon 22 Sep 25
Mon
22
Sep
Power BI DAX
Perth
Status: Scheduled
Scheduled
Wed 12 Nov 25
Wed
12
Nov
Power BI DAX
Perth
Status: Scheduled
Scheduled
Wed 10 Dec 25
Wed
10
Dec
Power BI DAX
Perth
Status: Confirmed
Confirmed
Remote West
Date
Course
City
Status
Fri 22 Aug 25
Fri
22
Aug
Power BI DAX
Remote West
Status: Confirmed
Confirmed
Mon 22 Sep 25
Mon
22
Sep
Power BI DAX
Remote West
Status: Confirmed
Confirmed
Wed 12 Nov 25
Wed
12
Nov
Power BI DAX
Remote West
Status: Scheduled
Scheduled
Wed 10 Dec 25
Wed
10
Dec
Power BI DAX
Remote West
Status: Confirmed
Confirmed
Scheduled
Taking enrollments.
Confirmed
Taking enrollments.
Few Seats left
Book Now.
Sold Out
Try another date.

Power BI Training Courses

Course Icon Power BI Beginner

Learn to use Power BI to create interactive dashboards, custom reports, analyse data and share insights.

download course pdf
Price: $395 $440
Course Icon Power BI Intermediate

Learn to build data models and calculations to produce intelligent dashboards. In-class and remote training.

download course pdf
Price: $595 $660
Course Icon Power BI Advanced

Advance your Power BI skills by learning DAX; Row Context, Functions, Calculated Columns, Measures and more.

download course pdf
Price: $595 $660
Course Icon Power BI Desktop Advanced Reporting

Master advanced Power BI reporting techniques in 1 day. Learn to create complex, layered, and interactive reports with custom visuals and navigation controls.

download course pdf
Price: $622 $690
Course Icon Power BI Data Transformation using Power Query

Learn Power Query for Excel and Power BI Desktop in 1 day. Master data transformation, query management, and M code to optimise your data workflows.

download course pdf
Price: $622 $690
Course Icon Data Visualisation with Power BI Desktop

Learn to create powerful visualisations and reports in Power BI Desktop in 1 day. Master data modelling, visualisation techniques, and report sharing.

download course pdf
Price: $622 $690
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.

Price: 

$2,170 inc GST

Power BI DAX Course Content

Expand All | Collapse All

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

Frequently asked questions

What is Power BI?

Power BI is Microsoft's powerful data visualisation tool that is commonly used for business analytics. With the ability to connect to data, clean and transform it, and create interactive dashboards, users can gain valuable insights to support informed decision-making. In our courses, you will gain hands-on experience using both Power BI Desktop and the Power BI service to create compelling visualisations. Learning Power BI has never been easier, and our courses will provide you with the skills you need to leverage this powerful tool effectively.

How difficult is Power BI Training?

The difficulty level of Microsoft Power BI courses can vary depending on factors such as prior experience with the Microsoft Power BI desktop itself, data analysis, familiarity with business intelligence concepts, and the depth of knowledge one aims to achieve. For beginners, Power BI training can present a learning curve as they navigate the platform's features, data modeling, visualisation techniques, and understanding DAX formulas. However, with the availability of comprehensive learning resources, official documentation, and training courses, individuals can gradually build their skills and proficiency in Power BI. The structured learning paths offered by Microsoft and the supportive online community further contribute to easing the learning process. With dedication, practice, and a willingness to learn, individuals can overcome the initial challenges and become proficient in leveraging Power BI effectively for data analysis and visualisation.

Will the content in these Power BI Courses be relevant for the workplace?

Our training courses for Microsoft Power BI are designed with a focus on real-world application, and our experienced course writers and trainers bring their industry backgrounds to the table to provide you with the knowledge and skills you need to achieve efficiency and productivity gains in your workplace. We offer a comprehensive curriculum that covers everything from the basics of visualisations to advanced data modelling and analysis, with an additional course for advanced users on the DAX language. By learning Power BI with us, you'll be equipped with the tools to create effective reports and dashboards, allowing you to excel with efficiency in your role.

How many students are typically in a Power BI Training Course?

At Nexacu, we deliver the highest quality of training where we strive to maintain a high level of quality instruction and foster active participation and dialogue. As such, we generally limit the number of students in each class to 5-8 individuals, with a maximum cap of 10. This approach ensures that you receive comprehensive and effective training, while also providing ample opportunities for asking questions and engaging in discussions with the instructor and fellow students. 

What is Remote Training?

Remote training means our team of experienced trainers will deliver your training virtually. With remote learning, students can access our usual classroom training courses via video conferencing, ask questions, participate in discussions and share their screen with the trainer if they need help at any point in the course. Students have the same level of participation and access to the trainer as they would in classroom training sessions. Essentially, you will learn Power BI from our Microsoft-certified trainers online. 

I previously attended a course with Excel Consulting, will the training be similar?

Yes, we rebranded from Excel Consulting in October 2019. The business quickly outgrew its original name. Our new brand Nexacu, better reflects our direction, continued innovation and commitment to deliver next-level learning. We have continually refined and updated our courses while retaining our excellent trainers and delivering the same high-quality content.

Where do I start with learning the Power BI Courses?

Check our Power BI Course syllabus to see our vast set our course offerings from Beginner, Intermediate, Advanced, and DAX, leading to the ultimate Microsoft Power BI certification. Starting with the Beginner course, you will develop a fundamental understanding of data visualization tools necessary for analyzing data and leveraging data analysis expressions. Proceeding with our Intermediate course, you will explore data analytics and data models necessary for data transformation. Our Advanced course offers a comprehensive introduction to DAX functions, features, and different Power BI tools. Finally, once you reach DAX, expect mastery of more complex DAX tools and achieve more in-depth Microsoft Power BI skills.

Why should I choose Nexacu?

With years of experience in delivering Microsoft Power BI training, Nexacu has successfully served a vast number of students who have enrolled in our Beginner, Intermediate, Advanced, and DAX courses. We take pride in offering highly coveted Power BI courses, which attracts professionals from diverse industries, eager to enhance their data analysis skills and excel in developing impactful BI reports. Join us on a journey towards becoming a data analysis expert with our comprehensive Power BI training programs. Our Microsoft Power BI training combines our highly successful courses, a comprehensive syllabus, the official exam, and certification, all at an exceptional value. For the price of four Power BI training courses, you'll also receive unlimited Microsoft practice exams, a free re-sit, unlimited study support, additional study materials, and the official Microsoft certification upon passing the exam. Propel your career in data analytics with this comprehensive package.

Course Details

Download Course PDF
Price
$595 $660
Duration
1 day
Times
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online

Course Details

Download Course PDF
Price
$595 $660
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 8
201 Charlotte Street
Brisbane QLD 4000

Course Details

Download Course PDF
Price
$595 $660
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 24/477 Pitt Street
Sydney
New South Wales 2000

Course Details

Download Course PDF
Price
$595 $660
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 12A
45 William Street Melbourne VIC 3000

Course Details

Download Course PDF
Price
$595 $660
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
NEW LOCATION
Level 2
221 London Circuit
Canberra ACT 2600

Course Details

Download Course PDF
Price
$595 $660
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 15
33 King William Street
Adelaide 5000

Course Details

Download Course PDF
Price
$595 $660
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 7
553 Hay Street
Perth WA 6000

Course Details

Download Course PDF
Price
$595 $660
Duration
1 day
Times
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online

skills test nexacu

Skills Test

Try our short skills test and find out which course is right for you.

 skills test

 

Contact Us

Can’t find a suitable date or have questions about the course? Fill out the form below, and our team will get back to you promptly.

Locations In-Person & Online

Find the nearest location and date that works for you

Locations In-Person & Online

Find the nearest location and date that works for you

Related Training Courses

Course Icon Power BI Beginner

Learn to use Power BI to create interactive dashboards, custom reports, analyse data and share insights.

download course pdf
Price: $395 $440
Course Icon Power BI Intermediate

Learn to build data models and calculations to produce intelligent dashboards. In-class and remote training.

download course pdf
Price: $595 $660
Course Icon Power BI Advanced

Advance your Power BI skills by learning DAX; Row Context, Functions, Calculated Columns, Measures and more.

download course pdf
Price: $595 $660
Course Icon Power BI Desktop Advanced Reporting

Master advanced Power BI reporting techniques in 1 day. Learn to create complex, layered, and interactive reports with custom visuals and navigation controls.

download course pdf
Price: $622 $690
Course Icon Power BI Data Transformation using Power Query

Learn Power Query for Excel and Power BI Desktop in 1 day. Master data transformation, query management, and M code to optimise your data workflows.

download course pdf
Price: $622 $690
Course Icon Data Visualisation with Power BI Desktop

Learn to create powerful visualisations and reports in Power BI Desktop in 1 day. Master data modelling, visualisation techniques, and report sharing.

download course pdf
Price: $622 $690
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.

Price: 

$2,170 inc GST

Locations In-Person & Online

Find the nearest location and date that works for you

Locations In-Person & Online

Find the nearest location and date that works for you

Trusted Nationwide by Leading Organisations

at 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

  • 400+ companies rely on Nexacu for team training
  • Trusted by federal, state, and local government agencies
  • Delivering training across 9 countries

Why Nexacu?

Books Icon

Step by Step Courseware

Custom workbook included with a step by step exercises

Facility Image 2
Facility Image 3
Facility Image 1

Refresh Icon

Free Refresher

Resit your course for free within 6 Months

More than 1,300 Business trust Nexacu

Trusted by Business

Procured by Government

Procured by Goverment

Reviews Not Found

Valued by Individuals