Power BI DAX Essentials | Online | Wed 9 Dec – Thu 10 Dec 2026

* Please note that this is an online course, delivered remotely by a live instructor through Zoom *

Course: PBIDAX

Duration: 2 Days

Overview

This intensive two-day Power BI DAX Essentials course is designed to establish a strong understanding of DAX fundamentals before progressing to more advanced calculations and techniques. The training is built around two core principles: practical application and active participation. Throughout the course, attendees will create DAX formulas in hands-on exercises, analyse the results, explore successful and unsuccessful outcomes, and gain a clear understanding of why certain approaches work better than others. Real-world, scenario-driven examples are used throughout every module to help reinforce concepts and ensure practical relevance.

By the end of the course, participants will have the confidence to develop DAX calculations that meet specific business requirements, apply proven techniques for troubleshooting and performance tuning, and utilise available resources to solve more complex analytical challenges. The course uses a single, consistent dataset from start to finish, allowing learners to focus on developing DAX skills and understanding key concepts without being distracted by changing data structures.

Audience

Power BI DAX Essentials is intended for business professionals – including those working in finance, marketing, operations, and other functional areas – as well as SQL Server reporting specialists who want to enhance their reports and dashboards through the creation of custom DAX-based calculations tailored to specific business needs.

Prerequisites

This course is ideal for individuals who have completed a foundational Power BI course or who already possess a solid understanding of data modelling principles. To gain maximum value from the training, participants should also be familiar with Excel formulas or have experience writing SQL queries, as these skills provide a useful foundation for learning DAX.

Module List

• Module 1: Getting to know Data Analysis Expression (DAX) Language

• Module 2: Data Modelling Recap

• Module 3: Calculated Columns and Measures

• Module 5: Evaluation Contexts in DAX

• Module 6: Table Functions

• Module 7: Creating Date Table

• Module 8: Basic Iterators

• Module 9: Variables in DAX

• Module 10: Advance Filtering in DAX

• Module 11: Context Transition

• Module 13: Conditionals in DAX

• Module 14: Hierarchies In DAX

Click here for the full 'Power BI DAX Essentials' course outline