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
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?!!