Chapter 3. Introduction to DAX

Now that you have seen some examples of Microsoft SQL Server PowerPivot for Excel worksheets, it is time to learn the fundamentals of PowerPivot expressions. PowerPivot has its own syntax for defining calculation expressions. It is conceptually similar to an Excel expression, but it has specific functions that allow you to create more advanced calculation on data stored in multiple tables. The PowerPivot language is called Data Analysis Expressions, but we always use the shorter DAX acronym.

In this chapter, you learn the basics of DAX and also discover how to use it to solve some typical problems in business scenarios.

Understanding Calculation in DAX

Just as it does in Excel, any calculation in DAX begins with the ...

Get Microsoft® PowerPivot for Excel® 2010 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.