Forum Discussion
Group and Concatenate
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.
My attempt -
Yields this error -
Any assitance is very much appreciated.
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.
1 Reply
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.