Forum Discussion
Helper IHow to display the most Latest Record
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
susheeltyagi
You can change the aggregation to MAX or
Create the following Measure: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 🙂
1 Reply
- Fowmy
Super User
susheeltyagi
You can change the aggregation to MAX or
Create the following Measure: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 🙂