Showing results for 
Search instead for 
Did you mean: 
Regular 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
Community Support

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
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors