+ Reply to Thread
Results 1 to 2 of 2

Variance in PowerPivot

  1. #1
    Registered User
    Join Date
    04-07-2011
    Location
    Montreal
    MS-Off Ver
    Excel 2010
    Posts
    11

    Variance in PowerPivot

    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
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    05-28-2013
    Location
    Belfast
    MS-Off Ver
    Excel 2013
    Posts
    1

    Re: Variance in PowerPivot

    Hi just wondering did you ever get a solution for this?
    I have the same problem at the moment.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1