Updated on

RankKind.Type specifies the type of ranking.

Enumeration Options

Enumerations simplify the process of selecting options within a function. To specify the RankKind.Type, users have the option to either input the below Argument description (which provides more information) or the shorter Value (which provides a more concise representation).

RankKind.Competition0Identical items receive the same rank. In case of identical items there is a gap before the next rank. This approach may generate non-sequential rankings, with the possibility of repeated rank numbers.
RankKind.Dense1Identical items receive the same rank and the next ranking item is numbered consecutively without gap. Method guarantees a ranking with consecutive numbers where a rank can appear multiple times.
RankKind.Ordinal2Every item, even those that are identical, gets a unique rank. Duplicate values get consecutive rankings.

Applies to

Here’s a list of functions that work with RankKind.Type:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/rankkind-type