Refer to previous/next row in a calculated column

[NNaj]

Hi All,

I am trying to create a calculated column which lists the value of the previous row of another column.

Any ideas on how to do this?

[Tahreem24 · Accepted solution]

@NNaj ,

1. Step 1: Go to Power Query Editor --> Add Column Option --> CLick on "Index Column" --> Apply and CLose.
2. Create Measure = CALCULATE(VALUES('Table'[Exchange]),'Table'[Index]-1)

Don't forget to hit Thumbs up and accept this as a solution if you find it helpful! 

[NNaj]

 Thank you for this. I created the index column, but want a calculated instead of the measure you described. I tried using the same equation in calculated column but it did not work. Any tips?

[Tahreem24]

@NNaj ,

Create column like below:

Column = CALCULATE(MAX('Table'[Exchange]),ALL('Table'),'Table'[Date]<EARLIER('Table'[Date]))

Don't forget to hit Thumbs up and accept this as a solution if you find it helpful! 

[Anonymous]

Hi @Tahreem24 how do I do this if I want it the other way around? 

Start	Output End
22/03/2020	28/03/2020
29/03/2020	30/03/2020
31/03/2020	04/04/2020
05/04/2020	11/04/2020
12/04/2020	13/04/2020
14/04/2020

Thank you