Forum Discussion
Solved
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 ...
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
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
Hey Gordonlilj
What If I want to calculate sum of all those differences and put it in a card?!!