SQLBits 2010

Implementing Common Business Calculations in DAX

This session will introduce the basic concepts of the new multidimensional calculation language, DAX, and show how to implement several common calculations in it
DAX is Microsoft's new multidimensional calculation language. At the moment it's only used in PowerPivot, but in the future it's likely to have an important role in other corporate BI products from Microsoft, so it's something that all BI consultants need to learn now. In this session we'll learn about the basic concepts of the language and see how it can be used to implement a number of common business calculations.