Sort ascending values by minimum value from each group
JOB AMOUNT JOB AMOUNT A -120A -120A 120A -35A -9A -9A -35A 120B 30F -110B -30F -90C 40F 50D -30D -35D -35D -30D 60D 60E -34E -34E 40E 40F -110B -30F 50B 30F -90C 40
Code:let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], Group = Table.Group(Source, {"JOB"}, {{"Count", each _, type table}}), ListMin = Table.AddColumn(Group, "Custom", each List.Min([Count][AMOUNT])), Expand = Table.ExpandTableColumn(ListMin, "Count", {"AMOUNT"}, {"AMOUNT"}), SortAsc = Table.Sort(Expand,{{"Custom", Order.Ascending}, {"AMOUNT", Order.Ascending}}), RC = Table.RemoveColumns(SortAsc,{"Custom"}) in RC






Bookmarks