6. Using Data Sheet View

This chapter is mostly about adding calculated columns in the PowerPivot data sheet. There are 71 DAX functions defined in this chapter, with examples.

Another 64 DAX functions are described in Chapter 10, “Using DAX for Aggregate Functions,” and Chapter 11, “Using DAX for Date Magic.”

Before launching into the DAX function reference, this chapter covers the commands available in the PowerPivot window. These include scrolling, sorting, formatting, and filtering.

Working with Data in ...

Get PowerPivot for the Data Analyst: Microsoft now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.