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

Appendix BMDX Queries for PowerPivot

MultiDimensional eXpressions (MDX) is a very powerful query language for extracting data from cubes. While PowerPivot can generate sophisticated MDX for you, you may want the total control that writing your own MDX gives you. You can use MDX to import from either an SSAS cube or a PowerPivot model that has been published to PowerPivot for SharePoint. This appendix demonstrates some of the fundamentals of MDX. It also shows how best to adapt your MDX for PowerPivot.

image Key concepts Cube dimensions and measures, Crossjoin() function, navigating hierarchies, ranges, sorting, filtering, calculated measures, key performance ...

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