Forum Discussion
Solved
Create a calculated column with shifted row values from an existing column
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.
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
ryan_mayu
Super User
Super Useryou 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