Showing results for 
Search instead for 
Did you mean: 
Not applicable

Can I subtract one filtered value from another?

Every month I import our department spend into Power BI to compare our budget vs actual spend. Obviously I have the budget for the full year, but only have spending data available to-date for actual spend. Each month I filter total budget spend by the YTD months (i.e. at the moment excluding May and June), so that it lines up with our actual spend.


I.e - 

Budget YTD: $110,000 (May-19 to Apr-20)

Actual spend YTD: $117,000


Is there a way to subtract the YTD Spend from the filtered YTD Budget (i.e. = -$7,000)? Obviously the filter changes each month.

Not sure if relevant, but our Actuals and Budget are in different sheets with a 1 to many connection.


Any questions let me know as I already typed this out once before getting signed out and having to start again!

Super User
Super User

Probably. Please see this post regarding How to Get Your Question Answered Quickly:

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors