LinkedIn Post by:
Brian Julius
solution
let
Source = Table.SelectRows( Excel.CurrentWorkbook(){[Name="Table1"]}[Content], each [Matches] >= 10),
AddAvgPts = Table.AddColumn(Source, "AvgPts", each [Total Points]/[Matches]),
Group = Table.Group(AddAvgPts, {"Group"}, {{"All", each _, type table [Group=text, Player=text, Matches=number, Total Points=number, AvgPts=number]}, {"MaxAvgPts", each List.Max([AvgPts]), type number}}),
Expand = Table.ExpandTableColumn(Group, "All", {"Player", "AvgPts"}, {"Player", "AvgPts"}),
FilterNClean = Table.SelectColumns( Table.SelectRows(Expand, each [AvgPts] = [MaxAvgPts]), {"Group", "Player"})
in
FilterNClean