Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to Solution.
I have managed to resolve this by adding ", " at the end of your function:
@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]))
I have managed to resolve this by adding ", " at the end of your function:
Now it is merging without comma e.g. "New YorkChicagoMinesota" - can you please advise how to separate those values with comma?
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |