Trying to merge a column into one row

[TheBIGuy_PBI]

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

[barritown · Accepted 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

My YouTube vlog in English

My YouTube vlog in Russian

[TheBIGuy_PBI]

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.

Treemap2 = SUMMARIZE (

            'Treemap', Treemap[QUESTIONTEXT],

            "Merged Answers", CONCATENATEX ( Treemap, Treemap[Answers Combined],

            UNICHAR(10) )

            )

Appreciate your help!!!!

Can't thank you enough for your help!!!!!!