O'Reilly logo

Practical PowerPivot & Dax Formulas For Excel® 2010 by Art Tennick

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required