Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |