Can I subtract one filtered value from another?

Anonymous — Wed, 20 May 2020 02:45:15 GMT

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!

Re: Can I subtract one filtered value from another?

Greg_Deckler — Wed, 20 May 2020 04:01:12 GMT

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.

topic Can I subtract one filtered value from another? in DAX Commands and Tips

Can I subtract one filtered value from another?

Re: Can I subtract one filtered value from another?