Table.AddRankColumn not recognized

[MikeBennett]

Hi

I am relatively new to the Power Query M Language. I am trying to use Table.AddRankColumn in the advanced editor and am getting an error. I am using Power BI Desktop September 2021.

As an example I try 

----------------------------------------------

let
tblTest = Table.AddRankColumn(
  Table.FromRecords({
    [CustomerID = 1, Name = "Bob", Revenue = 200],
    [CustomerID = 2, Name = "Jim", Revenue = 100],
    [CustomerID = 3, Name = "Paul", Revenue = 200],
    [CustomerID = 4, Name = "Ringo", Revenue = 50]
  }),
  "RevenueRank",
  {"Revenue", Order.Descending},
  [RankKind = RankKind.Competition]
)
in
tblTest

----------------------------------------------

I get the error "Expression.Error: The name 'Table.AddRankColumn' wasn't recognized. Make sure it's spelled correctly."

When I am writing the code the editor doesn't try to autofill Table.AddRankColumn like it does for other expressions. 

Does anybody have any ideas why I can't use the table expression?

Thanks Mike

[edhans · Accepted solution]

Table.AddRankColumn didn't exist in Sept 2021. You should be on a current version, at least April 2022 or later. June 2022 is already out. 

This is a very new function. Not sure exactly when it came out, but Excel doesn't support it yet in Power Query - unless you are perhaps on Insider builds.

By the way, once you get to a current version, stay reasonably up to date. MS stops supporting old versions and they never fix bugs in old versions. June 2022 is out, and it doesn't matter if they find a HUGE bug in the May 2022 version. The fix is, install the June version.