Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Reference Previous Row Without Sorting & Index

Hi, I have a datasheet with a [depth] value, a [dollar] value, and a [category] value.   I would like to create a column that references the [dollar] value from the previous [depth] row, for each [...
Need Help
latimeria's avatar
latimeria
Solution Specialist
3 years ago

Hi Anonymous ,

 

You can try adding the columns and shifting 1 row down .

You tranform the table into lists:

AllLIsts = Table.toColumns()
ShiftList = null & Table.RemoveLastN( , 1)[mycol]

and then you concatenate again.

Allists & mylist and Table.FromColumns

Video from Goodly here: https://www.youtube.com/watch?v=a7O2UlbTAvA

and here https://www.youtube.com/watch?v=IGF2-qfzDQs

I would be interested to know whether it's faster