Forum Discussion

MarcusClaudius's avatar
MarcusClaudius
Regular Visitor
8 years ago

Building Variance Reports in Power BI

To all     I'm trying to replicate the Variance Reports which I am currently producing in Excel.   The columns are your standard collections of Actuals v Budget, on month, and YTD. Followed by F...
Tutorial Requests
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

Probably, would want sample data and expected output. Your current report screen shots would help. See this Quick Measure:

 

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008

 

For examples of calculating variances between years, etc.

 

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

MarcusClaudius's avatar
MarcusClaudius
Regular Visitor
8 years ago

Greg

 

I've just posted a few examples of the kinds of Excel reports that I produce.

 

Thanks for your help

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    hi,@MarcusClaudius

      you can use TOTALYTD Function and TOTALMTD Function to create the measure like this:

    SaleYTD = TOTALYTD(CALCULATE(SUM(Table1[sales])),'Date'[Date])

    For example

    and use SAMEPERIODLASTYEAR Function create the measure

    Previous sales=CALCULATE(SUM(Table1[sales]), SAMEPERIODLASTYEAR('Date'[Date]))

    Then use these measures and other fields to create your report.

     

    Best Regards,

    Lin