Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a table like this
ID | Name |
1 | Anne |
1 | Bob |
2 | Cara |
2 | Doug |
3 | Ed |
3 | Fannie |
I want the table to look like this
ID | Names |
1 | Anne, Bob |
2 | Cara, Doug |
3 | Ed, Fannie |
Solved! Go to Solution.
Hi
Group Column, choose "Sum" and replace List.Sum by Text.Combine
= Table.Group(Source, {"ID"}, {{"Data", eachList.Sum([Name]), type nullable text}})
= Table.Group(Source, {"ID"}, {{"Data", each Text.Combine([Name],", "), type nullable text}})
Stéphane
Hi
Group Column, choose "Sum" and replace List.Sum by Text.Combine
= Table.Group(Source, {"ID"}, {{"Data", eachList.Sum([Name]), type nullable text}})
= Table.Group(Source, {"ID"}, {{"Data", each Text.Combine([Name],", "), type nullable text}})
Stéphane
That worked! Thank you so much!
There are a few ways to do this.
Something like this will work...
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8nRR0lHyS8xNVYrViVYyBHIc8/IQHKf8JDDbCMh2TixKhHNc8kvTwRxjIMc1Bc50S8zLywTqjwUA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"(blank)" = _t, #"(blank).1" = _t]),
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
#"Grouped Rows" = Table.Group(#"Promoted Headers", {"ID"}, {{"Names", each _, type table [ID=nullable text, Name=nullable text]}}),
Custom1 = Table.AddColumn(#"Grouped Rows", "namesOnly", each Combiner.CombineTextByDelimiter(", ")(Table.Column(Table.SelectColumns([Names], "Name"), "Name"))),
#"Removed Columns" = Table.RemoveColumns(Custom1,{"Names"})
in
#"Removed Columns"
Proud to be a Super User! | |
Check out the July 2025 Power BI update to learn about new features.