Chapter 3. Introducing DAX
Now that you have seen some of the features of Microsoft PowerPivot for Microsoft Excel 2013, it is time to learn the fundamentals of the DAX language. 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 calculations on data stored in multiple tables. (The PowerPivot language is called the Data Analysis eXpressions language, but we always use the shorter DAX acronym.)
In this chapter, you will learn the basics of DAX and how to use it to solve some typical problems in business scenarios.
Understanding DAX calculations
Just like Excel, any calculation in DAX begins with the assignment operator. ...
Get Microsoft Excel 2013: Building Data Models with PowerPivot now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
