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.
Hi, I'm trying to take a table and merge the "Answers combined" into one row, grouped by the QuestionText. It's probably easier than I think but everything I try has not worked.
Any help on this would be really appreciated. I've been able to use the ConcatenateX function in PowerQuery, but it just combines everything. I'm trying to combine them by QuestionText.
A few guys here have helpful, taking me part of the way, but this is the step where I'm stuck
Any help is appreciated.
Thanks, Steve
Solved! Go to Solution.
Hi @TheBIGuy_PBI,
I guess you need such a measure:
Here it is in the text format for convenience:
Merged = CONCATENATEX ( data, data[Answer], UNICHAR(10) )
The same option works if you want to create a separate table with the merged answers:
Table with Merged Answers =
SUMMARIZE ( data, data[Question],
"Merged Answers", CONCATENATEX ( data, data[Answer], UNICHAR(10) ) )
Best Regards,
Alexander
Hi @TheBIGuy_PBI,
I guess you need such a measure:
Here it is in the text format for convenience:
Merged = CONCATENATEX ( data, data[Answer], UNICHAR(10) )
The same option works if you want to create a separate table with the merged answers:
Table with Merged Answers =
SUMMARIZE ( data, data[Question],
"Merged Answers", CONCATENATEX ( data, data[Answer], UNICHAR(10) ) )
Best Regards,
Alexander
Holy sh**! This worked perfectly. I took your suggestion and modified it, but your solution was the perfect template for me to get my project done.
I was able to complete the project with this code and some formatting to get the job done.
Can't thank you enough for your help!!!!!!
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 |
---|---|
60 | |
60 | |
54 | |
38 | |
27 |
User | Count |
---|---|
86 | |
61 | |
45 | |
41 | |
39 |