Data of Different Grains: A Followup
User Rating: / 0
PoorBest 
Written by Rob Collie   
Thursday, 19 January 2012 17:40

In last week's post, I explained how PowerPivot can very easily help you solve the "Budget vs. Actuals" problem or any other problem where you have data sets of different granularities that you want to compare in a single report.

The crux of the problem in my example was that my Budget table only budgeted down to the Month level whereas my Sales table went down to the day level.

Read more...

  Tags: dax, format
 

Varigence Vivid