O'Reilly logo

Practical PowerPivot & Dax Formulas For Excel® 2010 by Art Tennick

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

Chapter 2PowerPivot: Overview

Chapter 1 was a very quick introduction to PowerPivot for Excel. It concentrated on importing data from SQL Server. This chapter takes a more detailed look at importing data from SQL Server. It also shows how to import data from Access, Excel, and data feeds. You are shown relationships between PowerPivot tables and how to set them up, if they are missing. Data Analysis eXpressions (DAX) is used to create both calculated columns in PowerPivot tables and measures in PowerPivot pivot tables in Excel. In addition, a measure is added through the GUI, without the need for DAX. You get to construct a sophisticated pivot table and a pivot chart linked to the pivot table. Various ways of filtering data in a pivot report ...

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