O'Reilly logo

PowerPivot for the Data Analyst: Microsoft by Bill Jelen

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

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

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