Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello users,
I'm working on a report to show Planned cost vs Actual Cost by month with accumulative.
The planned cost is fixe for the full year 12months, for this reason it not linked to Calendar table. I'm limited and I cant create any new relationships in "Analysis Service" for geting DATA.
I used this meaure for Actual as it is changing every month(Transaction), but this measure is not working for Planned value(Even I created a new measure = divide Planned /12
Hello @Hindlaz,
Can you please try the following:
1. Distributing the Planned Cost
Monthly Planned Cost =
DIVIDE(
[Total Planned Cost],
12,
0
)
2. Cumulative Planned Cost
Cumulative Planned Cost =
CALCULATE(
[Monthly Planned Cost],
FILTER(
ALLSELECTED('Calendar'[Date]),
'Calendar'[Date] <= MAX('Calendar'[Date])
)
)
Hello Sahir,
Thank you for your reply,
Unfortunatlly, the cumulative is noy working, tired other function but still have only the divided value