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