Group and Concatenate

[X3svfdB1HOjKYc0]

I have this list.

I would like to keep one record per article ID and have the MM_MMW_Detailed column repeat with a delimiter (preferably a line break but any other delimiter would also be acceptable).

It looks like there is an accepted solution to my question but I can't get it to work.

https://community.powerbi.com/t5/Desktop/Agroup-and-concatenate-column-with-a-common-value/m-p/21186...

My attempt -

Yields this error -

Any assitance is very much appreciated.

[mussaenda · Accepted solution]

Hi @X3svfdB1HOjKYc0,

You cannot aggregate your Detailed column with sum because your data type is a string.

Your frist step is correct, you need to group them.

Then instead of aggregating, select all columns without aggregations.

Then create a custom colmn to concat the Detailed column.

I attached a sample pbix for your guide.