Power Query（M语言），删除重复项，如何实现保留最后一行

cqwcns

我发现power query删除重复项，默认是保留第一行的，而我希望保留最后一行。
我尝试先降序（日期列），再删除重复项，发现排序步骤对删除重复项是没有效果的。
以下代码，虽然操作了降序，但删除重复项仍是保留day1的。

[HTML] 纯文本查看 复制代码

let
    源 = Table.FromRecords({
    [day = 1, Name = "Bob", Phone = "123-4567"],
    [day = 1, Name = "Jim", Phone = "987-6543"],
    [day = 1, Name = "Paul", Phone = "543-7890"],
    [day = 1, Name = "Bob", Phone = "123-4567"],
    [day = 1, Name = "Jim", Phone = "987-6543"],
    [day = 2, Name = "Paul", Phone = "543-7890"],
    [day = 2, Name = "Bob", Phone = "123-4567"],
    [day = 2, Name = "Jim", Phone = "987-6543"],
    [day = 2, Name = "Paul", Phone = "543-7890"],
    [day = 2, Name = "Bob", Phone = "123-4567"],
    [day = 2, Name = "Jim", Phone = "987-6543"],
    [day = 3, Name = "Paul", Phone = "543-7890"],
    [day = 3, Name = "Bob", Phone = "123-4567"],
    [day = 5, Name = "Jim", Phone = "987-6543"],
    [day = 6, Name = "Paul", Phone = "543-7890"],
    [day = 6, Name = "Bob", Phone = "123-4567"],
    [day = 6, Name = "Jim", Phone = "987-6543"],
    [day = 6, Name = "Paul", Phone = "543-7890"]
    }),
    排序的行 = Table.Sort(源,{{"day", Order.Descending}}),
    删除的副本 = Table.Distinct(排序的行, {"Name"})
in
    删除的副本

所以，一般这种需求如何实现？
请大佬指教，感谢。

放羊的狼

价格buff试试

放羊的狼

试了一下，加了buffer可以达到你的要求

[C] 纯文本查看 复制代码

let
    源 = Table.FromRecords({
    [day = 1, Name = "Bob", Phone = "123-4567"],
    [day = 1, Name = "Jim", Phone = "987-6543"],
    [day = 1, Name = "Paul", Phone = "543-7890"],
    [day = 1, Name = "Bob", Phone = "123-4567"],
    [day = 1, Name = "Jim", Phone = "987-6543"],
    [day = 2, Name = "Paul", Phone = "543-7890"],
    [day = 2, Name = "Bob", Phone = "123-4567"],
    [day = 2, Name = "Jim", Phone = "987-6543"],
    [day = 2, Name = "Paul", Phone = "543-7890"],
    [day = 2, Name = "Bob", Phone = "123-4567"],
    [day = 2, Name = "Jim", Phone = "987-6543"],
    [day = 3, Name = "Paul", Phone = "543-7890"],
    [day = 3, Name = "Bob", Phone = "123-4567"],
    [day = 5, Name = "Jim", Phone = "987-6543"],
    [day = 6, Name = "Paul", Phone = "543-7890"],
    [day = 6, Name = "Bob", Phone = "123-4567"],
    [day = 6, Name = "Jim", Phone = "987-6543"],
    [day = 6, Name = "Paul", Phone = "543-7890"]
    }),
    排序的行 = Table.Buffer(Table.Sort(源,{{"day", Order.Descending}})),
    删除的副本 = Table.Distinct(排序的行, {"Name"})
in
    删除的副本

50lovelace

排序了后面加一步：添加索引列  再删除就可以了