Understanding DAX Pillars

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.

- 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