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 6Fundamental Functions: Filter, Logical, and Miscellaneous Functions

This is a wide-ranging chapter on some of the fundamental DAX functions. It includes syntax and examples for all of the Filter functions and all of the Logical functions. In addition, it discusses some other functions—for example, those that are often referred to as Information or IS() functions. An example is ISBLANK(). There is also one Text function, BLANK(), which has been added here because of its close relationship to ISBLANK(). The Filter functions, in particular, are extremely powerful. Among other things, they allow you to override the filter context that a user chooses in a pivot table. They help to display classic BI values such as “percentage of parent” or ...

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