cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Card visual - calculate difference between actual and budget

I am trying to present a visual that shows the difference between average daily spend per month compared to the budgeted spend in a card.

 

I can display the Daily average with a column such as 

DailyAvgVBudget = CALCULATE(SUM([Spend])/AVERAGE([MonthWorkingDays])).
 
However, if I try to calcuate the difference by subtracting the budgeted daily figure (either as a constant or retrieved from a field) I get a strange result nowhere near the expected answer.
 
Things I've tried include;
DailyAvgVBudget = CALCULATE(SUM([Spend])/AVERAGE([MonthWorkingDays])) - 37859
 
DailyAvgVBudget = CALCULATE(SUM([Spend])/AVERAGE([MonthWorkingDays]) - AVERAGE(Budget[Daily]) )
 

Am I trying to achieve the impossible?  Surely not...

 

5 REPLIES 5
Highlighted
Community Support
Community Support

Re: Card visual - calculate difference between actual and budget

Hi @garycarters ,

 

Could you please share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Highlighted
Helper I
Helper I

Re: Card visual - calculate difference between actual and budget

https://1drv.ms/u/s!Amo6JxqZkuIlad7zkbxiKSakac0 

 

This is the data set I am using.

Highlighted
Community Support
Community Support

Re: Card visual - calculate difference between actual and budget

Hi @garycarters ,

 

Seemed that I cannot access the file by the link. Could you please share it again?

333.PNG

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Highlighted
Helper I
Helper I

Re: Card visual - calculate difference between actual and budget

Highlighted
Community Support
Community Support

Re: Card visual - calculate difference between actual and budget

Hi @garycarters ,

 

Same error..

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

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.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors