Create a calculated column with shifted row values from an existing column

[Reda899]

Hi guys,

As illustrated below, I would like to shift cell values up with 3 cells. I need this to be a new calucated column.

[ryan_mayu · Accepted solution]

@Reda899 

you can create an index column , and use DAX to create another column

Column 2 = 
VAR _index='Table'[Index]+3
return maxx(FILTER('Table','Table'[Index]=_index),'Table'[Column1])

here is another workaround, you don't need to get the value, you just need to create a new column

Column 3 = 'Table'[column]-1