How to display the most Latest Record

[susheeltyagi]

Hi,

I am new in Power BI. I would like to get the latest records (most recent timestamp) per Serial No.

Currently I am getting the below :

My Expectation is :

Table Name = Devices

SerialNo             Status                  Timestamp
090500925     Connected            2020-09-03 12:06:21

031000694      Connected           2020-09-03 08:51:57

Please help me

Thanks

Susheel

[FrankAT]

Hi @susheeltyagi 

take a look at the following solution:

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

[Fowmy · Accepted solution]

@susheeltyagi 

You can create ht ebelow measure and assign it to the Visual Filter of the Table Visial and set it to 1

Measure = 
VAR SN = MAX(Devices[SERIAL NO]) RETURN
VAR _MAX = MAXX(
    FILTER( ALL(Devices),
        Devices[SERIAL NO] = SN
    ),
    Devices[TIME STATUS]
)

RETURN

IF( SELECTEDVALUE(Devices[TIME STATUS]) = _MAX , 1,0)

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn