Monday, June 24, 2013

PowerPivot Nuggets - Part 20 - Create Time Dimension Office App

›
Over the last few years I have created many PowerPivot models and almost every single one of them had a calendar dimension.   One of the top...
Friday, July 20, 2012

PowerPivot Nuggets - Part 19 - Automate PowerPivot Refresh with Excel 2013

›
Earlier this week Microsoft released the Office 2013 Customer Preview.  PowerPivot and Power View are now first class citizens in Excel, how...
3 comments:
Tuesday, July 10, 2012

PowerPivot Nuggets - Part 18 - SWITCH() and multiple expressions

›
SWITCH() is a new function introduced in PowerPivot v2.  SWITCH() is a great alternative for nested IF() functions in DAX.  Let's have l...
Friday, March 30, 2012

PowerPivot Nuggets - Part 17 - Visualize KPI Trends

›
KPIs are a nice new feature in PowerPivot 2012.  I blogged about KPIs before.    In PowerPivot KPIs have a value, a target and a status. ...
2 comments:
Thursday, February 09, 2012

PowerPivot Nuggets - Part 16 - Berekening Voordeel Alle Aard (VAA) Bedrijfswagens

›
In Belgium there is a lot of buzz going around the higher taxes on company cars.  In Dutch it's called "Voordeel Alle Aard".  ...

PowerPivot Nuggets - Part 15 - What If Analysis with Slicers

›
Relationships are one of the cornerstones of PowerPivot.  In general every PowerPivot workbook should have relationships defined in the mode...
2 comments:
Wednesday, February 01, 2012

PowerPivot Nuggets - Part 14 - Generate a list with all your DAX calculations

›
As your PowerPivot workbooks grow larger and contain more calculation the urge for some kind of documentation becomes stronger.  In this Pow...
Wednesday, December 07, 2011

PowerPivot Nuggets - Part 13 - Save PowerPivot workbook as Analysis Services Cube

›
Consider the following scenario's: A business person created a PowerPivot workbook, but is struggling with some more advanced DAX. A...