Calculate difference between consecutive rows / columns

[PowerEnthusiast]

Please help...

I am currently running through a similar issue, in that I would like to display the differences between values.

     Column 1 | Column 2 | Column 3 | Column 4 | Column 5

           200           100            350            900              800

Diff:           -100          +250          +550            -100

Please help. I would real really appreciate the assistance. 

Thanks. 

[Anonymous]

@PowerEnthusiast  - It would be straightforward to create a new Calculated Column for each of those values - is that what you're looking for? If so, here is an example:

Diff One vs Two = [Column 1] - [Column 2]

If that is not what you're looking for, could you please elaborate on the desired behavior?

Cheers,

Nathan

[PowerEnthusiast]

Thank you for the reply.

Apologies, I am new to all this. 

I have various account names that needed to be sorted, so I included an index field. Then I wanted to calculate the difference between the Account Names, but ensuring that the difference is calculated in the order as shown below. 

[Gordonlilj · Accepted solution]

Hi,

You could try and create this calculated column

Calculated column = 
VAR RowAbove=
CALCULATE (
SUM (Table[Value]),
FILTER (Table, Table[Index] = EARLIER (Table[Index]) - 1))
RETURN
Table[Value] - RowAbove

[Anonymous]

Hey @Gordonlilj 
What If I want to calculate sum of all those differences and put it in a card?!!

[PowerEnthusiast]

@Gordonlilj Oh wow thank you so much. This is perfect. 

Appreciate the help.