Cumulative difference

[learner03]

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

[ribisht17]

Hi ,akakapoor,

NOTE: Add a custom index column first Creating an Index column using a Power Query - Power BI Docs

Step 1 

Prev = CALCULATE(sum('Cumulative Diff'[Qty]),

FILTER(all('Cumulative Diff'),('Cumulative Diff'[Index.1]+1) =

max('Cumulative Diff'[Index.1])))

Step 2

Cumulative Difference =([Prev])-CALCULATE(sum('Cumulative Diff'[Qty]))

Last Step = /get the - at the top

Final Output = IF(min('Cumulative Diff'[Index.1])=1,"-",'Cumulative Diff'[Cumu Diff]) 

Regards,

Ritesh

Please mark the answer as a solution if it helps you so that it can help others as well

[learner03]

@ribisht17 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 · Accepted solution]

So, you need to just reverse the order Cumulative Difference =([Prev])-CALCULATE(sum('Cumulative Diff'[Qty])) here, right?

>> Keep Calculate first 

Regards,

Ritesh