Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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))
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |