SQLBits 2014

DAX Patterns

Learn ready-to-use DAX patterns improving development speed of Power Pivot solutions. Good also for SSAS Tabular developers.
The DAX language has a low number of built-in functions, but it is very flexible and you can write complex calculations with it. It is so flexible that you might find many alternative ways to write an expression solving a business problem. You can save development time by adapting an existing DAX Pattern to your specific scenario. This session will present a set of fundamental patterns you have to know in DAX, because they are used very often in many business scenarios and are already tested and optimized, saving you from the effort of choosing between different possible optimizations.