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.
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!!!!!!
User | Count |
---|---|
76 | |
75 | |
46 | |
31 | |
28 |
User | Count |
---|---|
99 | |
91 | |
51 | |
49 | |
46 |