Forum Discussion
Max Date for Employee Column
I have the following table:
| Date | Emp ID |
| 1/2/2019 | 325 |
| 1/3/2019 | 326 |
| 1/4/2019 | 325 |
| 1/5/2019 | 326 |
| 1/7/2019 | 401 |
| 1/8/2019 | 401 |
I'd like to get the result:
| Emp ID | Max Date |
| 325 | 1/4/2019 |
| 326 | 1/5/2019 |
| 401 | 1/8/2019 |
Does anyone know how to do this in DAX?
Hi Anonymous ,
I think you might have created a column instead of a measure.
In my answer, I created a measure.
The result will be wrong if you created a calculated column.
Best Regards,
Eads
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Hi Anonymous ,
You just need a measure to use MAX() function.
Max Date = MAX ( test[Date] )
Then you can use a table visual to get result.
Don’t summarize the value of Emp ID.
Best Regards,
Eads
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
I think you might have created a column instead of a measure.
In my answer, I created a measure.
The result will be wrong if you created a calculated column.
Best Regards,
Eads
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.