Forum Discussion
Solved
Merging data in one column as per unique column in same table
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"...
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 , You can use this measure in the display table
concatenatex(Table, Table[City])
New table = summarize(Table, Table[Country], "City",concatenatex(Table, Table[City]))
Now it is merging without comma e.g. "New YorkChicagoMinesota" - can you please advise how to separate those values with comma?
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!