Table.AddRankColumn

語法

Table.AddRankColumn(table as table, newColumnName as text, comparisonCriteria as any, optional options as nullable record) as table

關於

將名為 newColumnName 的資料行附加至 table，並使用一或多個 comparisonCriteria 所述的其他資料行進行排名。 進階使用者可以使用 RankKind 中的 options 選項來挑選更明確的排名方法。

範例 1

將一個名為 RevenueRank 的資料行新增至資料表中，並將 Revenue 資料行從最高到最低排名。

使用方式

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

輸出

Table.FromRecords({
    [CustomerID = 1, Name = "Bob", Revenue = 200, RevenueRank = 1],
    [CustomerID = 3, Name = "Paul", Revenue = 200, RevenueRank = 1],
    [CustomerID = 2, Name = "Jim", Revenue = 100, RevenueRank = 3],
    [CustomerID = 4, Name = "Ringo", Revenue = 50, RevenueRank = 4]
})

相關內容

比較準則