Forum Discussion

ivanuska's avatar
ivanuska
Icon for Advocate I rankAdvocate I
5 years ago
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"...
Need Help
  • ivanuska's avatar
    ivanuska
    5 years ago

    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!
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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's avatar
    ivanuska
    Icon for Advocate I rankAdvocate I
    5 years ago

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

  • ivanuska's avatar
    ivanuska
    Icon for Advocate I rankAdvocate I
    5 years ago

    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!