Search code examples
functionpowerbipowerqueryrankm

RANK function in/for Power Query

Need RANK function in Power Query, Like in Excel, SQL, DAX...

The Best answers for now:

  1. Built in Table.AddRankColumn function available since Jun-2022
  2. Solution with the best performance, at least at my test (~10% better then built Table.AddRankColumn).
Solution

  • MS recently released a rank function in M.

    This satisfies all requirements like ties, dense rank etc.

    https://learn.microsoft.com/en-us/powerquery-m/table-addrankcolumn