LASTNONBLANK sorting on a different column

Question

I have a time stamp column and a value column:&nbsp;deviceData[Timestamp]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;deviceData[Value]0900&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 21.270855&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22.89&nbsp;&nbsp;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&nbsp;Can I use the LASTNONBLANK function to return the last value?&nbsp;I am trying this: Latest Percentage = LASTNONBLANK(deviceData[Value], MAX(deviceData[Timestamp))&nbsp;&nbsp;&nbsp;&nbsp;

anonymous · Answer

Hi tabhowells,
&nbsp;
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.
&nbsp;
Regards,
Xiaoxin Sheng

Forum Discussion

LASTNONBLANK sorting on a different column

1 Reply

Related content

Sorting

Table Sort , sort order , comparer

sorting matrix

LastNonBlank Value

conditional lastnonblank