Forum Discussion
Latest value
I need to get the latest value based on a given data when record is selected. If i select record # 1 = the result will be "E", but if the date filter is set to year 2021, the result will be "B" ...
CJ_96601 Try:
Measure =
VAR __Date = MAX('Table'[Date])
VAR __Result = MAXX(FILTER('Table',[Date] = __Date),[Score])
RETURN
__Result
Thanks..but it is not working.
it wasn't giving the latest score