How to filter "Last Know Value" in Power BI
This video demonstrates how to filter the last value using Power BI DAX command LASTNONVALUE
Video Content
0:00 Getting Ready
02:30 New Measure
02:58 Overview of LASTNONBLANK
03:51 Editing LASTNONBLANK
04:49 Editing FILTER
06:05 Display Filtered Time & Date
06:27 Problems with page filters
Here is the DAX command in full
Last_Time = CALCULATE(LASTNONBLANK(Query1[EventEnqueuedUtcTime], 1), FILTER(ALL(Query1), Query1[EventEnqueuedUtcTime] = MAX(Query1[EventEnqueuedUtcTime])))