Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
Hi @GTPowerBIUser ,
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.
Hi @GTPowerBIUser ,
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.
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])
Hi @GTPowerBIUser ,
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.
You are right! Thank you!
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |