Mastering DAX Workshop

United States

DAX is the native language of semantic models in Power BI, Fabric, Analysis Services, and Power Pivot for Excel. The training is aimed at users of Power BI and Power Pivot for Excel, and at Analysis Services developers who want to learn and master DAX.

The goal of this three-day, classroom course is for the expert trainer to teach all the features of the DAX language, providing the knowledge to write formulas for common and advanced business scenarios. All attendees will receive a digital copy of the book, The Definitive Guide to DAX - 3rd edition.

The classroom course includes hands-on labs: you will apply the concepts using your own notebook.

2027 Classroom Courses: Register Now

Secure your seat for any delivery date in the first half of 2027 and get an additional early-registration discount.

Full refund, guaranteed.
If you later decide not to attend, or if we cannot schedule a course in a location that works for you, we refund you in full. No risk.

How locations and dates are decided:
We use prepaid registrations to decide how many editions to run and where. A cluster of registrations in the same area is what places a course there. If we cannot run the course near you, you can get a full refund or consider attending another nearby city.

Why the discount:
The earlier you register, the clearer the picture we have for planning cities and number of editions. That is why early registrations receive an additional discount. This is not about collecting money before year-end; it is about making better decisions about where and how often to run the courses.

You can register now. We will announce cities and dates in January 2027, or as soon as the registrations give us a clear direction.

Topics

  • DAX syntax
  • User-defined functions
  • Filter context
  • Row context
  • Table functions
  • Semi-additive calculations
  • Time intelligence (calendar-based and classic)
  • Window functions
  • Calculation groups
  • Inside CALCULATE
  • Advanced Relationships
Mastering DAX Outline (PDF)

Prerequisites

Attendees need basic knowledge of Power BI Desktop, or Analysis Services Tabular, or Power Pivot for Excel.

We strongly suggest attendees watch the free Introducing DAX video course prior to attending the Mastering DAX classroom course. This ensures proper basic knowledge of the language to start Mastering DAX. A minimum of 3-6 months of DAX experience is usually suggested to get the most out of the Mastering DAX classroom course.

All hands-on labs are based on Power BI; reasonable user interface knowledge is recommended, though the same DAX concepts can also be applied to Fabric, Power Pivot for Excel, and Analysis Services.

Location to be announced

United States

Teaching this course

Marco Russo & Alberto Ferrari

Consultants & Mentors
Trainer for 420 other courses at SQLBI

Looking for another city?

We bring our classroom courses to you all over the world. Here are the current scheduled classroom courses.
Please note that each classroom course is taught exclusively by SQLBI trainers in person. No external trainers are involved.
 London, England, GB Nov 24-26
London
 Amsterdam, NL Dec 1-3
Amsterdam
Other locations On-Site On-Site On-Site On-Site