Can I subtract one filtered value from another?

[Anonymous]

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!

[Greg_Deckler]

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

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.