Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I created the measure below to calculate the costs budget from now because there are no actuals. Unfortunately it only calculates the budget for the upcoming months and not for the remaining days of the current month.
Budgetfrom now = CALCULATE(
SUM(Budget[Amount])
;FILTER(
DimDate
;DimDate[Date] > TODAY()
)
)
The last column shows my budget starting in the coming month. What i would like to see is also the amount i can expect for the current month. I see two options:
- show the budget until the month is over;
- show the budget for the days left this month. For example it's now the 2nd of the month so i want to see 106045,02 (budget whole month) / 31 (days this month) *29 (days left this month).
Hi Oomsen,
You measure seems no problem, could you share some of your data, especially the Date column for further test?
Regards,
Jimmy Tao