Merging data in one column as per unique column in same table

[ivanuska]

Hi guys,

I am new to Power BI and would need your help. I've got the example of dataset and would need to merge the lines in "Country" column as per unique values and concatenate inputs in "City" column separated by comma - perhaps using Measure (as Calculated column would create duplicate entries). Please find below details:

Existing dataset:

Result should be:

Country	City
France	Paris
USA	New York, Chicago, Minesota
Germany	Berlin
Italy	Rome

Thank you for any suggestion!

[amitchandak]

@ivanuska , You can use this measure in the display table

concatenatex(Table, Table[City])

New table = summarize(Table, Table[Country], "City",concatenatex(Table, Table[City]))

[ivanuska · Accepted solution]

I have managed to resolve this by adding ", " at the end of your function:

New table = summarize('Table', 'Table'[Country], "City",concatenatex('Table', 'Table'[City], ", "))

Thank you for help!

[ivanuska]

Now it is merging without comma e.g. "New YorkChicagoMinesota" - can you please advise how to separate those values with comma?