skip to Main Content

Dax WhitepaperCouple quick things today.

First, Howie Dickerman, one of the SuperHeroes of DAX, has written a new version of the DAX whitepaper.

I had a chance to discuss some of it in person with Howie when I was in Redmond.  It opened my eyes to a number of things I had been missing.  I sadly have not had time to review it in detail yet – there are other things (good things) afoot at PivotStream these days…  like, um, I dunno, our first industrial-strength PowerPivot farm in the sky…  but I plan to get back to DAX shortly.

In the meantime, I have posted the updated whitepaper in the Samples Gallery out on the FAQ Site.

PowerPivot Architecture Poster

Also, Denny Lee shared an excellent new poster that displays all the components of the PowerPivot architecture.  I’ve also uploaded that to the Samples Gallery

Note that the poster is HUGE, meant to truly be a poster, so it’s not really something you view in a web page.  Hence the PDF format.  It’s also available in other formats.


Rob Collie

One of the founding engineers behind Power Pivot during his 14-year career at Microsoft, and creator of the world’s first cloud Power Pivot service, Rob is one of the foremost authorities on self-service business intelligence and next-generation spreadsheet technology.

This Post Has 5 Comments
    1. No, that is not intentional. I can download it without signing in.

      Will you send me a screenshot of exactly what you are seeing? Would be helpful to see the entire browser window, where you are clicking, AND the login prompt.

  1. Hi,

    I have a need to suppress zero rows (or blank rows) in Excel OLAP Pivot Table (Excel 2013-2016). Excel is sourcing data from SSAS Cube 2012.

    The Excel Value Filter works, however, it has severe limitations when addressing contra entries across a row i.e. if a row has 2 columns one w +5 and another w -5, it eliminates that row. Whilst Essbase & Cognos seem to handle it gracefully, I don’t know if there are any good Excel third party tools that does the same. Or perhaps you could suggest a suitable work around.

    Thank you,

Leave a Comment or Question