Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Devices with latest status based on the time

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.

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Anonymous , 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 )

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@Anonymous , 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 )

Anonymous
Not applicable

Thank you so much it works

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.