Forum Discussion
Cumulative sum with gaps in axis
Hello all,
I am working with cumultavies over time but instead of months I am calculating cumulatives based on diffrence of two months [Completion_Vs_Contract] this is as well in my axis however I have there some gaps and cumulative might go down in gap months.
For example my monhts are -12 -11 -10 -9 -8 -6 -3 -2 -1 0 1 2 3
Is there way of taking this gaps into conisderation?
Vintage Cumulative =
CALCULATE (
[Settlements],
FILTER (
ALL (
Terminations[Completion_Vs_Contract]
),
Terminations[Completion_Vs_Contract] <= MAX ( Terminations[Completion_Vs_Contract] )
)
)
Many thanks.
Andrej
Vintage Cumulative = CALCULATE ( [Settlements], FILTER ( ALL ( Terminations[Completion_Vs_Contract] ), Terminations[Completion_Vs_Contract] <= MAX ( Terminations[Completion_Vs_Contract] ) ) ) * DIVIDE( [Settlements], [Settlements] )Add divide function with your calculation and that will do it.
2 Replies
- parry2k
Super User
Vintage Cumulative = CALCULATE ( [Settlements], FILTER ( ALL ( Terminations[Completion_Vs_Contract] ), Terminations[Completion_Vs_Contract] <= MAX ( Terminations[Completion_Vs_Contract] ) ) ) * DIVIDE( [Settlements], [Settlements] )Add divide function with your calculation and that will do it.
- AndrejZitnay
Post Patron