Forum Discussion
susheeltyagi
Helper I
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 = Devic...
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 🙂
Fowmy
Super User
Super Usersusheeltyagi
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 🙂