Chapter 9. PowerPivot DAX Patterns

In this chapter, we show you many common DAX calculations using techniques that can be easily applied to your own Microsoft SQL Server PowerPivot for Excel models. As you will see, DAX calculations might have significant differences from one another, depending on the underlying data model. For this reason, you should be sure that you understand the data modeling concepts presented in Chapter 4, of this book.

Calculating Ratio and Percentage

In Chapter 8, you saw some of the Excel features that allow you to show a value as a percentage of a total. However, you might need to make this calculation in a measure or in a calculated column, for example, because you need that number as part of another calculation.

Calculating ...

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.