DAX course
Become an expert in advanced calculations across Power BI and Power Pivot.
The DAX course is for anyone who wants to master advanced calculations inside Power BI or modern pivot tables in Excel - from the writing standards to iterators, context transition and managing tables.
Course goal
Familiarize participants with the advanced capabilities of the DAX language for writing formulas inside Power Pivot and Power BI. You will learn the core concepts and writing standards, as well as advanced topics such as iterators, context transition and managing tables.
Who it is for
The course is intended for advanced PivotTable and Power Pivot users who want to expand their capabilities or need to process large volumes of data (tens of millions of rows).
Notes
- The course can be taken through Power BI or Excel.
- For Excel you need at least Excel 2016 (or the Power Pivot add-on for older versions down to Excel 2010). Excel 365 is recommended.
Course content
Introduction
- What Power Pivot / Tabular is and why it became a core Microsoft BI tool.
- How Power Pivot differs from ordinary pivot tables.
- What DAX is and how to learn it.
Measures vs calculated columns
- Field types in a visual; explicit vs implicit measures and filter context.
- Calculated columns and row context - when to use which.
Iterator and table functions
- Iterator syntax (e.g. SUMX) and usage.
- Grouping functions: ALL, VALUES, CROSSJOIN.
- Iterative table functions (FILTER, ADDCOLUMNS), DAX Studio, and turning tables into scalars.
Data model
- Optimal structures: filter and value columns, dimensions vs fact tables.
- Relationships: 1:*, *:*, filter direction, active vs inactive relationships.
- Propagation of filter and row context.
The CALCULATE function
- Syntax and filter argument types (modifiers, tables).
- Expanded tables and the crossfilter concept.
- Evaluation order and the transition from row to filter context.
Variables and advanced topics
- Defining and using variables (scalars and tables), nested row context.
- Introduction to calculation groups.
- Implementing time intelligence calculations.
Why choose us?
We have run 60+ training sessions and share knowledge built over 10+ years of working with Power Query and DAX - we have used Power BI since its 2015 launch. Alongside training we actively deliver implementations (60+ successful projects), so we stay current with the whole ecosystem.
Get in touch with any questions about the DAX course and request an offer.
Request an offer
Krešimir Ledinski
Microsoft Certified Trainer (MCT) and Power Platform consultant. He has taught Power BI, Power Query and DAX for more than 8 years, and has worked with Microsoft data tools for over 10 - across 60+ system implementations on Power BI, Fabric and the Power Platform. He knows data modeling, DAX and M programming inside out, as well as where Power BI fits in the wider data stack, and was an early adopter of AI/LLMs in modern data solutions. In his courses he ties theory to real projects from FMCG, finance and retail, so attendees leave with knowledge they can apply right away.
View profile →Courses most often taken alongside this one
Request an offer
Tell us what you need and we'll get back to you shortly. We'll know your message is about DAX course.
A selection of the domestic and international clients we have worked with.
