Hello,
Would anyone be able to help to calculate a variance between two annual totals in PowerPivot?
As in the attached file, I have sales per month in 2010, 2011 and a forecast for 2012. What I need to do is to calculate the Qty, Price and Sales variance between the annual totals of 2010 and the annual totals of the 2012 forecast, in both Qty/$ and %.
Note that Price, Qty and Sales are the values of the PowerPivot, not Column or Row labels.
My table is called Sales Data with columns:
Qty
Price
Sales (= to Qty*Price)
Data Set (this column contains either 'Sales' or 'Forecast' values)
Year (2010, 2011 and 2012)
I was thinking of calculating a new column using DAX, but was not able to do so. Not sure whether a measure would help.
Thank you for your help
Rad
Bookmarks