I’m sure this is very easy to do – however, I can’t figure it out.
I have the following tables:
GF Balance [balance], [date]
GF Expenses [budgeted expenses], [date]
We have an internal requirement to keep General Fund Balance above 3-months of budgeted expenses.
I created the following measures:
1. Total Expense Budget = sum( GF Expense[budgeted expenses]) 2. Avg Monthly Expenses = divide( [total expense budget], 12) 3. Reserves = calculate( [avg monthly expenses] * 3)
If I slice for the year (2018) and put in a table the result is as expected
Total Expense Budget | Avg Monthly Expenses | Reserves
236,444 19,703.67 59,111
When I put in a table with Month, Balance, Reserves
January 88,892.43 4,207.00 and so on.
In a graph, the monthly balance shows as expected. But I need the 3-month reserves (59,111) to show across the year.
Thanks for your help!