How to filter "Last Know Value" in Power BI

  Рет қаралды 262

IOT Connectivity Simplified

IOT Connectivity Simplified

Күн бұрын

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

Пікірлер
Overview of Microsoft Power BI Gauges
28:44
IOT Connectivity Simplified
Рет қаралды 535
Introducing CALCULATE in DAX
13:57
SQLBI
Рет қаралды 86 М.
Minecraft: Who made MINGLE the best? 🤔 #Shorts
00:34
Twi Shorts
Рет қаралды 46 МЛН
Шаурма с сюрпризом
00:16
Новостной Гусь
Рет қаралды 6 МЛН
Cute dog Won Squid Game 😱💸 #dog # funny #cartoon
00:33
Wooffey
Рет қаралды 21 МЛН
КОГДА БАТЯ ПОЛУЧИЛ ТРАВМУ НА РАБОТЕ😂#shorts
00:59
Microsoft Power BI Alarms & Conditional Formatting
13:31
IOT Connectivity Simplified
Рет қаралды 162
Show last 13 Months from Slicer Selection in Power BI (DAX)
9:49
Overview of LoRaWAN
30:08
IOT Connectivity Simplified
Рет қаралды 365
How to add custom graphics to Power BI
13:00
IOT Connectivity Simplified
Рет қаралды 234
Overview of Node Red Average Nodes
10:24
IOT Connectivity Simplified
Рет қаралды 1,2 М.
Set Default Slicer Selection to Current Year or Month in Power BI
14:34
The Top 5 DAX you need to know before your next Data Analyst Interview
23:14
Minecraft: Who made MINGLE the best? 🤔 #Shorts
00:34
Twi Shorts
Рет қаралды 46 МЛН