Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
96 | |
79 | |
67 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |