Forum Discussion

tabhowells's avatar
tabhowells
Regular Visitor
9 years ago

LASTNONBLANK sorting on a different column

I have a time stamp column and a value column:   deviceData[Timestamp]           deviceData[Value] 0900                                        21.27 0855                                        22...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi tabhowells,

 

Lastnonblank not support return different column.

In my opinion, you can use lastnonblank get the last value, then use lookupvalue function to get the specific column.

 

Regards,

Xiaoxin Sheng