Forum Discussion

Dunner2020's avatar
Dunner2020
Icon for Post Prodigy rankPost Prodigy
6 years ago

Creating new column values based on previous rows value

Hi there,   I have a table that contains 3 columns (index, Waste Value, Running total of waste value). I want to create or populate new column/measure  (let say called Replaced Value) in such a way...
Need Help
Show and Tell
Tutorial Requests
Dunner2020's avatar
Dunner2020
Icon for Post Prodigy rankPost Prodigy
6 years ago

But how do we select the number of earlier observations? I have also added the sample data.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Question is not clear, But you can try like this. Both are new columns


Last Date Time = maxx(filter(table,table[Date Time]<earlier(table[Date Time])),table[Date Time])
Last value = maxx(filter(table,table[Date Time] =earlier(table[Last Date Time])),table[value])

. 

  • Dunner2020's avatar
    Dunner2020
    Icon for Post Prodigy rankPost Prodigy
    6 years ago

    Hi amitchandak 

    Sorry for the confusion, I have added more explanation. Hopefully that make sense now.