Filter based on summarize dax

[sunny27]

Hi,

How can we summarize the following data?

EmployeeNumber	Status	Date
100	1	1/1/2017
100	2	2/1/2017
100	3	3/1/2017
100	4	4/1/2017
101	1	4/25/2017
101	2	5/25/2017
102	2	3/10/2017
103	2	4/10/2017
104	1	5/10/2017
105	1	6/10/2017
106	1	7/10/2017
106	2	8/10/2017
106	3	9/10/2017
106	4	10/10/2017

I want to display max(date) for the Employees. In this case the output will be:

EmployeeNumber	Status	Date
100	4	4/1/2017
101	2	5/25/2017
102	2	3/10/2017
103	2	4/10/2017
104	1	5/10/2017
105	1	6/10/2017
106	4	10/10/2017

How can we do this? I tried to summarize and Group by but it's not working.

[Anonymous · Accepted solution]

Could you simply include them in a matrix and use "Latest Date" and "Max of Status"?