Forum Discussion

Reda899's avatar
Reda899
Frequent Visitor
4 years ago
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.

 

 

Need Help
Show and Tell
Tips and Tricks
  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    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

     

1 Reply

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    4 years ago

    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