Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi
I have the data source as below in which I need to concatenate a specific column based on the row identifier. Can you please help me in acxhiving this through DAX?
S No | Name | Purchased Item |
1 | Sam | Cloth |
2 | Chris | Food |
1 | Sam | Gift |
3 | Peter | Shoes |
2 | Chris | Tickets |
4 | Dean | Flowers |
3 | Peter | Candy |
Expected Result:
S No | Name | Purchased Items - Concatenated |
1 | Sam | Cloth, Gift |
2 | Chris | Food, Tickets |
3 | Peter | Shoes, Candy |
4 | Dean | Flowers |
Solved! Go to Solution.
Try this measure:
Purchased Items - Concatenated =
CONCATENATEX ( SUMMARIZE ( 'Table', 'Table'[S No], 'Table'[Purchased Item] ), 'Table'[Purchased Item], ", " )
Proud to be a Super User!
Hello @hasarinfareeth ,
Use below dax for your purpose :
This will be slightly better in performance than SUMMERIZE.
GROUPBY
This function works similarly to SUMMERIZE , but instead of calculating aggregations, it just groups by the specified columns. Since you're not performing any aggregation (like summing or counting), GroupBY can be more direct and semantically cleaner in this context.
I hope this helps.
Did I answer your query ? Mark this as solution if this helps.
Warm Regards,
Neeraj Kumar
Hello @hasarinfareeth ,
Use below dax for your purpose :
This will be slightly better in performance than SUMMERIZE.
GROUPBY
This function works similarly to SUMMERIZE , but instead of calculating aggregations, it just groups by the specified columns. Since you're not performing any aggregation (like summing or counting), GroupBY can be more direct and semantically cleaner in this context.
I hope this helps.
Did I answer your query ? Mark this as solution if this helps.
Warm Regards,
Neeraj Kumar
Try this measure:
Purchased Items - Concatenated =
CONCATENATEX ( SUMMARIZE ( 'Table', 'Table'[S No], 'Table'[Purchased Item] ), 'Table'[Purchased Item], ", " )
Proud to be a Super User!
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
72 | |
38 | |
31 | |
26 |
User | Count |
---|---|
95 | |
50 | |
43 | |
40 | |
35 |