cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Variance vs. Budget

Dear All,

 

I want to calculate the variance 2016 vs. BU 2016 with a database like below.
What is the most efficient way to proceed? thank you for your support !! Sly

 

data.png

2 REPLIES 2
Highlighted
Continued Contributor
Continued Contributor

Re: Variance vs. Budget

One way to do it is to add another value column that would be a lookup to get the matching BU 2016 value for each 2016 value:

 

Compare Value = LOOKUPVALUE(Sheet1[Value],[Year],"BU 2016",[Month],[Month],[Category],[Category])

 

And then a second column for the difference:

 

Difference = Sheet1[Value]-Sheet1[Compare Value]

 

For example:

 

Difference.jpg

 

Then you would filter your visual to display only 2016 values, and get this:

 

s.jpg

 

Connect with me in LinkedIn: https://pr.linkedin.com/in/adolfosocorro
Follow me on Twitter: https://twitter.com/AdolfoSocorro
Highlighted
Frequent Visitor

Re: Variance vs. Budget

Thank you very much for your answer.
Unfortunatelly, my database is more detailled as I have another column called "sub category" wih the name of all the employees...
This subcategory is changing every month (= people leaving or joining the company) so the matching is not possible.

Any other ideas?

 

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors