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 dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Here's a table with the results I seek:
col_1 | col_2 | result |
ape | bee | ape,bee |
house | street | house,street |
Now I have something like this (see below), where I collect each column that starts with "col_" (for up front I don't know how many columns there are) and use that information ('MyColumns') to create a custom column "result":
...
MyColumns = List.Buffer(List.Select(Table.ColumnNames(#"PreviousStep"), each Text.StartsWith(_, "col_"))),
#"Merged Columns" = Table.AddColumn(#"PreviousStep", "result", each Text.Combine(MyColumns, ";"), type text)
This results in "col_1,col_2", which is not what I need 😞
I hope someone can help. Thanks!
Solved! Go to Solution.
Try this as the next step:
= Table.AddColumn(#"Merged Columns", "Custom",
(r) => Text.Combine(List.Transform(MyColumns, each Record.Field(r, _)), ","),
type text)
This turns the list of columns into the values in those columns and concatenates the list with Text.Combine.
Try this as the next step:
= Table.AddColumn(#"Merged Columns", "Custom",
(r) => Text.Combine(List.Transform(MyColumns, each Record.Field(r, _)), ","),
type text)
This turns the list of columns into the values in those columns and concatenates the list with Text.Combine.
Wow Thanks it works perfectly !! Thank you mate!
Hi @AlexisOlson, thanks!
Do I understand correctly that (r) is a function referencing each record?
Yes. There's nothing special about the letter "r" but I needed to give it a name so that I could distinguish between the list environment and the row (record) environment when writing Record.Field(r, _).
Understood, thanks for the explanation!
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
10 | |
8 | |
6 | |
6 | |
6 |