Forum Discussion
olimilo
Post Prodigy
Post ProdigyHow to get the most recent evaluation (with context)?
I have 2 tables, an Employee table with a list of employees, and the other a list of their Evaluations. I would like to know how can I get the most recent of evaluation of each employee? Sample table...
HI olimilo
This is a sample file with the solution https://www.dropbox.com/t/R7hQZY8UPeD2n6x9Last Evaluation = CALCULATE ( MAX ( Evaluations[EvalID] ), Evaluations[Date] = MAX ( Evaluations[Date] ) )
tamerj1
Community Champion
Community ChampionHI olimilo
This is a sample file with the solution https://www.dropbox.com/t/R7hQZY8UPeD2n6x9
Last Evaluation =
CALCULATE ( MAX ( Evaluations[EvalID] ), Evaluations[Date] = MAX ( Evaluations[Date] ) )