Devices with latest status based on the time

[ysailan]

I have a dataset connected live to the Power BI dataset using Azure Analytics Streams.

I would like to show a table visualization showing all the devices with their latest status based on the time.

Please note I can not use power query, only I can create measure as the data is coming from the Power Bi dataset.

ID	Time	Status	Status Flag
1001	08/04/2021 04:04:21	00	Offline
1001	08/04/2021 04:04:20	10	Online
1002	08/04/2021 04:04:19	10	Online

Expected output:

ID	Time	Status	Status Flag
1001	08/04/2021 04:04:21	00	Offline
1002	08/04/2021 04:04:19	10	Online

Thank you in advance for your help.

[amitchandak · Accepted solution]

@ysailan , In a visual, take ID,  time, max of time, and create two measures like the one given below status flag and status

Status flag final=
VAR __id = MAX ('Table'[ID] )
VAR __date = CALCULATE ( MAX('Table'[Time] ), ALLSELECTED ('Table' ), 'Table'[ID] = __id )
CALCULATE ( max ('Table'[Status Flag] ), VALUES ('Table'[ID] ),'Table'[ID] = __id,'Table'[Time] = __date )

[ysailan]

Thank you so much it works