Category Archives: Pivots

London Data Culture Day 2015

Posted on December 15, 2015 by wessexbob

At the recent London Data Culture Day, organised by Jen Stirrup, I gave a presentation on Excel Cube Functions, querying a SQL Server database uploaded into Power Pivot to provide the cube, focusing on using MDX to enhance the capability … Continue reading →

Posted in CUBE Functions, Excel, Pivots, Power BI, Power Pivot, Uncategorized | Tagged | Leave a comment

Just One Slice Please

Posted on March 17, 2014 by wessexbob

We all use pivot tables, don’t we? And with the introduction of slicers, we have a much more friendly and nicer way of filtering the results than the old pivot filters. One drawback of slicers is that it is not … Continue reading →

Posted in Pivots, Power Pivot | Tagged , , , , , | 21 Comments