Forum Discussion
Calculate difference between consecutive rows / columns
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.
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
5 Replies
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
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.
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
