Hi all,
I have a big issue creating a measure, that will give me the budget for the full fiscal year, which is september 30th. Even if I in the example have focused on 1 year, the budget is made for several years and I need a correct calculation for all years.
My ultimate goal is to calculate the remaining budget, but I expect that to be a peace of cake, when this one works (reducing total fiscal year budget with budget ytd for all month.
I found a solution that AmitChandak created which is like this when I transformed to my data:
This year Budget =
CALCULATE (
SUM ( G_L_Budget_Entries[amount] ),
DATESYTD (
ENDOFYEAR (
'Calendar'[Date] ),
"09/30"
)
)
which worked correctly for the first 3 month (see picture below),
I tried to transform the formula to the one below, and it helped a bit (I got the last 9 month)(the measure Total Budget Amount = SUM ( G_L_Budget_Entries[amount] ) ).
Full Year Budget =
TOTALYTD(
[Total Budget Amount],
ENDOFYEAR(
'Calendar'[Date],
"09/30"
)
)
I really hope somebody can see what I am doing wrong and give me a solution that works.
regards
Jørgen