Dear Team, It would helpful to have Rank Unique function. The existing Rankx function has only two options dense and skip. To avoid ties, another option like "Ordinal Ranking" in power query (Ordin...
Other BI software vendors have been able to do this natively for years/decades.
Currently in order to break ties, you need to add an additional calculation based on a secondary ranking of a column to the original column you are ranking by; it is very cumbersome and convoluted.
