Showing results for 
Search instead for 
Did you mean: 
tabhowells Frequent Visitor
Frequent Visitor

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.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))





Community Support Team
Community Support Team

Re: LASTNONBLANK sorting on a different column

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.



Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

For learning resources/Release notes, please visit: | |

Helpful resources

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 132 members 1,776 guests
Please welcome our newest community members: