6. Using Data Sheet View
In This Chapter
Working with Data in the PowerPivot Window 101
Adding New Columns Using DAX Formulas 110
Grabbing Values from a Related Table 142
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® 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.
