Forum Discussion
Solved
Power Query - Need help to group and sort column Member ID and sort column Member Name accordingly
Hi, I have this table structure whereby I need to group "Member ID" column and sorted it alphabetically and combine it with a delimiter "-", and also the dependent column called "Member name" has to...
Hi
let
Source = Your_Source
Group = Table.Group(Source, {"Group ID", "Group Desc"}, {{"Data", each Table.Sort(_,{{"Member ID", Order.Ascending}})}}),
Member = Table.AddColumn(Group, "Member ID", each Text.Combine([Data][Member ID],"-")),
Name = Table.AddColumn(Member, "Member Name", each Text.Combine([Data][Member Name],"-"))
in
NameStéphane
Hi
let
Source = Your_Source
Group = Table.Group(Source, {"Group ID", "Group Desc"}, {{"Data", each Table.Sort(_,{{"Member ID", Order.Ascending}})}}),
Member = Table.AddColumn(Group, "Member ID", each Text.Combine([Data][Member ID],"-")),
Name = Table.AddColumn(Member, "Member Name", each Text.Combine([Data][Member Name],"-"))
in
Name
Stéphane
