Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
13 | |
8 | |
8 | |
7 |
User | Count |
---|---|
17 | |
13 | |
7 | |
6 | |
6 |