Learning DAX can be tricky, especially if you have a background in SQL.
The FILTER function does not create a new filter context but a row context. The ROW function is executed in a filter context without creating a row context. To demystify this and all the other DAX Gotchas that I bumped into is the goal of my session.
Best bractices in DAX formulas from real world experience.
Deep dive into the handling of many to many relationships in DAX. How to make them work and how to optimize their speed thorugh many patterns and live examples of M2M usage.
This session will introduce the basic concepts of the new multidimensional calculation language, DAX, and show how to implement several common calculations in it