Forum Discussion
How can I identify the latest edited records?
Hello I have a list A, 1, 2/1/19 A, 2, 3/1/19 B. 1. 1/1/19 ... How can I lookup the first field and return the second and the third field only from the record that is the latest in the th...
Hi Anonymous ,
Use the below measure
Latest =
var _a = MAX('Table'[Date])
var _previousdate = CALCULATE(MIN('Table'[Date]),FILTER(ALLEXCEPT('Table','Table'[Customer]), 'Table'[Date] > _a))
var _d = IF(ISBLANK(_previousdate),COUNTROWS('Table'))
RETURN
_d
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)