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 [link removed due to 404] 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 [link removed due to 404] 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 original engineering leaders behind Power BI and Power Pivot during his 14-year career at Microsoft, Rob Collie founded a consulting company in 2013 that is 100% devoted to “the new way forward” made possible by Power BI and its related technologies. Since 2013, PowerPivotPro has rapidly grown to become the leading firm in the industry, pioneering an agile, results-first methodology never before seen in the Business Intelligence space. A sought-after public speaker and author of the #1-selling Power BI book, Rob and his team would like to help you revolutionize your business and your career.

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