Forum Discussion
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!
1 Reply
- Greg_Deckler
Community Champion
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.
