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've learned how to create a rank [Start Date] grouped by [Clients Personal ID] in Ascending order from table Client
Formula
Example
Clients Personal ID Start Date ClientFirstEntry
3487 9/30/22 1
3487 11/1/22 2
Clients Personal ID Start Date ClientLatestEntry
3487 9/30/22 2
3487 11/1/22 1
Have you tried providing 'DESC' in the place of ''ASC". If so what's the output you got? If not try it that should help to solve your problem.
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
Hi Kishore,
Replacing "ASC" with "DESC" only switched the rows but not that vaules. Please see below.
Clients Personal ID | Start_Date | ClientFirstEntry | ClientlatestEntry |
3487 | Tuesday, September 20, 2022 | 1 | 2 |
3487 | Tuesday, November 1, 2022 | 2 | 1 |
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.