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 .  
  • amitchandak's avatar
    4 years ago

    Anonymous , Try a new column like

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