Required - Dax formula for calculating incremental figure from cumulative column.
image attached with formula used:-
Incremental MI =
CALCULATE([Target MI Measure],
FILTER(‘Milestone Table’,
‘Milestone Table’[Milestone No] < EARLIER(‘Milestone Table’[Milestone No])))
But not getting desired result.
Required result
0 - 0
1 - 87500
2 - 87500
3 - 87500
4 - 87500
@vikashmukim Can you try this?
Incremental MI =
VAR CurrentMilestone = 'Milestone Table'[Milestone No]
RETURN
CALCULATE(
[Target MI Measure],
FILTER(
'Milestone Table',
'Milestone Table'[Milestone No] < CurrentMilestone
)
)
Let me know if that works for you. Thanks
@vikashmukim Is it possible for you to share the PBIX?
@MohammedHuzefaBagwan I think vikashmukim is looking to get the previous Target MI value, based on the Milestone No, and then deduct in from the current rows Target MI, based off their required results.
As its a calculated column do you think it may be related to the measure being used? I would have expected the current value of the row to have the VAR of the previous row deducted from it. Whereas it looks like the measure being used is summing all Target M! values with a Milestone No less than the current row’s.
We can also use Milestone Date column instead of Milestone no, just desired results are needed.
I have attached the PBIX file.
Mi - Working 2.pbix (20.4 KB)
@vikashmukim Please see the attached solved PBIX.
I hope this is something you were looking for.
Do let me know if that works for you. Thanks
SOLVED Mi - Working 2.pbix (22.5 KB)
Thanks @MohammedHuzefaBagwan .
Really appreciate.
