RankKind.Type

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).

ArgumentValueDescription
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:

BI Gorilla Blog

Last update: August 17, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/rankkind-type
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.