22-25 April 2026 Browse the 2026 agenda
Analytics
Understanding DAX Pillars
Description
DAX is a simple language (but not easy at all). Its pillars, though, need to be clearly understood in order not to get confused when they interact between them in your measures, calculated columns or calculated tables. In this session the five DAX pillars (filter context, row context, context transition, iterators and expanded tables) will be explained, with examples, one by one first and then in interaction between them. Examples will be in increasing complexity order.
Learning Objectives
- Understanding DAX fundamentals concept one by one
- Merge these concepts gradually into more and more complex calculations
- Apply these concepts to real life business cases
- Merge these concepts gradually into more and more complex calculations
- Apply these concepts to real life business cases
Things I will need
Power BI Desktop and Analyze in Excel per Power BI Desktop Installed into the computer
Tech Covered
Power BI, Modelling, Analytics, Reporting and Visualisation, Development, DAX, Data Internals – Blow Your Mind, Workshop, 2 years +