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.
Hi,
My data has multiple rows with similar values (See Source number). I need to rank source number to be able to carry out further analysis. After applying RANKX function, i get rank in the following manner. It skips numbers in between, due to multiple rows.
Source Number | Reason | Rank |
24563 | Null | 1 |
24563 | Null | 1 |
24563 | Invalid | 1 |
24563 | Invalid | 1 |
24563 | Invalid | 1 |
23456 | Null | 11 |
23456 | Invalid | 11 |
23456 | Invalid | 11 |
23456 | Null | 11 |
24534 | null | 6 |
24534 | null | 6 |
24534 | Invalid | 6 |
24534 | null | 6 |
I need my data to look like this:
Source Number | Reason | Rank |
24563 | Null | 1 |
24563 | Null | 1 |
24563 | Invalid | 1 |
24563 | Invalid | 1 |
24563 | Invalid | 1 |
23456 | Null | 3 |
23456 | Invalid | 3 |
23456 | Invalid | 3 |
23456 | Null | 3 |
24534 | null | 2 |
24534 | null | 2 |
24534 | Invalid | 2 |
24534 | null | 2 |
Can you please help with the right logic
Thanks in Advance.
Solved! Go to Solution.
@Anonymous change the last argument of RANKX from Skip to Dense
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
@Anonymous change the last argument of RANKX from Skip to Dense
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
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 |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |