Max Date for Employee Column

[Anonymous]

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?

[v-eachen-msft]

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.

[Anonymous]

I wish it was that easy. When I tried that I got the max date for the entire column, not the one for the employee column. In sql I would have done something like, max([date] for [employee])

[v-eachen-msft · Accepted solution]

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.

[Anonymous]

You are right! Thank you!