Forum Discussion
learner03
Post Partisan
Post PartisanCumulative difference
How can I get cumulative difference as below? Qty Cumulative difference 105 - 111 -6 23 88 45 -22 100 -55 76 24 45 31 63 -18
So, you need to just reverse the order Cumulative Difference =([Prev])-CALCULATE(sum('Cumulative Diff'[Qty])) here, right?
>> Keep Calculate first
Regards,
Ritesh
learner03Post Partisan
Post Partisanribisht17 I tried with the above and I am getting below view as per my data-
The dates are rolling14 days. This is giving me opposite output, example-Bins Count OUT were more than the previous day, so basically 22 more were completed than previous day, but this is showing -22.
How can I make it Positive?
ribisht17
Super User
Super UserSo, you need to just reverse the order Cumulative Difference =([Prev])-CALCULATE(sum('Cumulative Diff'[Qty])) here, right?
>> Keep Calculate first
Regards,
Ritesh