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