Chapter 4DAX: Overview

Data Analysis eXpressions (DAX) is a new language that makes its debut with PowerPivot for Excel. It is a language designed to use formulas, which in turn are based on one or more DAX functions. Some of its functions will look familiar to veteran Excel users, although there are differences between DAX and Excel functions. These differences are elaborated in this chapter. You will learn where and how to write DAX functions and formulas, and there are a number of examples to try. The all-important concept of filter context is discussed in detail. Other topics include data types and operator precedence. Two of the most popular functions, RELATED() and CALCULATE(), are covered in depth. The difference between DAX calculated ...

Get Practical PowerPivot & DAX Formulas for Excel 2010 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.