Forum Discussion
Solved
Filter based on summarize dax
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.
