LASTNONBLANK sorting on a different column

[tabhowells]

I have a time stamp column and a value column:

deviceData[Timestamp]           deviceData[Value]

0900                                        21.27

0855                                        22.89

I need to return the latest value in a powerbi visual, so in the instance above I want 21.27 to be returned since this is the "current" value in the table

Can I use the LASTNONBLANK function to return the last value?

I am trying this: Latest Percentage = LASTNONBLANK(deviceData[Value], MAX(deviceData[Timestamp))

[v-shex-msft]

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