How to get the most recent evaluation (with context)?

[olimilo]

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 tables below:

Employee table

EID	Name
1	Jane
2	Jen
3	Jin
4	John
5	June

Evaluations table

EID	EvalID	Date
1	1	1-Jan-22
1	2	1-Feb-22
2	1	1-Jan-22
2	2	1-Feb-22
2	3	1-Mar-22
3	1	1-Apr-22
4	1	1-Apr-22
4	2	1-May-22
5	1	1-Apr-22
5	2	1-May-22
5	3	1-Jun-22

I am combining both tables into one table visual.

[tamerj1 · Accepted solution]

HI @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] ) )