Filter column with item that has latest date

[Datagulf]

I have a table where I have duplicate items each with a task and a time component of when the task started.

ID	Email	Task	Time
1	person1@email.com	Task1	23/08/2022  14:08:00
1	person1@email.com	Task2	23/08/2022  16:52:17
1	person1@email.com	Task3	24/08/2022  01:52:17
2	person2@email.com	Task1	23/08/2022  15:52:17
2	person2@email.com	Task2	23/08/2022  21:37:45
3	person3@email.com	Task1	23/08/2022  15:52:18
3	person3@email.com	Task2	23/08/2022  21:00:10
3	person3@email.com	Task3	24/08/2022  15:52:17
4	person4@email.com	Task1	23/08/2022  22:54:45
5	person5@email.com	Task1	24/08/2022  00:45:41

I would like to get the last date per each email in a table visual. How would I be able to achieve that?

[PaulDBrown · Accepted solution]

Try:

Max date per person =
CALCULATE ( MAX ( Table[Time] ), ALLEXCEPT ( Table, Table[ID] ) )