Forum Discussion
Solved
Look for an expected blank/missing entry
I have the following data sample and I'm looking to show the below. Every business day the doors are UNLOCKED in the morning and locked in the evening. I need to show the current status of each doo...
Hi burnttoast - you can create a measure to dynamically retrieve the most recent status as like below:
Latest Status =VAR LatestDate = MAX('Lockd'[LatestDate])RETURNCALCULATE(MAX('Lockd'[status]),'Lockd'[LatestDate] = LatestDate)
Hi burnttoast - you can create a measure to dynamically retrieve the most recent status as like below:
Latest Status =
VAR LatestDate = MAX('Lockd'[LatestDate])
RETURN
CALCULATE(
MAX('Lockd'[status]),
'Lockd'[LatestDate] = LatestDate
)
Thanks rajendraongole1,
Thant's done the trick.