Forum Discussion
Calculate difference between consecutive rows / columns
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
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
Hey Gordonlilj
What If I want to calculate sum of all those differences and put it in a card?!!