Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Benchmark (i+1) values with (i)

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 .

 

  • Anonymous , Try a new column like

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

1 Reply

  • Anonymous , Try a new column like

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