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