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 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.
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] ) )
1 Reply
- tamerj1
Community Champion
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] ) )