Benchmark (i+1) values with (i)

[Anonymous]

Hello,
is it possible some how to load values of (i+1) on the same row of (i). It should be iterative for each row till last. 
"i" is an integer. 
Thank you .

[amitchandak · Accepted solution]

@Anonymous , Try a new column like

maxx(filter(Table, [Column1] =earlier([Column])+1 ),[var2])