Forum Discussion
Chewbaklava
3 years agoFrequent Visitor
Concatenate multiple rows using a DAX measure
Hi all,
Here is an example table that i'm trying to write a measure for. My goal is to output a concatenated string of participants for each unique ID.
| ID | Participant |
| 001 | John |
| 001 | Terry |
| 001 | Albert |
| 002 | Susan |
| 002 | Roger |
| 003 | Sally |
| 003 | Tom |
| 003 | Chewbaklava |
Participants Conc = CALCULATE(CONCATENATEX(table, <expression>, "; ")
I'm struggling with the expression piece.
My visual will have columns: ID & [Participants Conc]:
| ID | Participants Conc |
| 001 | John; Terry; Albert |
| 002 | Susan; Roger |
| 003 | Sally; Tom; Chewbaklava |
Thanks for any suggestions or advice
Hi, Chewbaklava
Please try formula like
Participants = CONCATENATEX(FILTER('Table','Table'[ID]=MAX('Table'[ID])),'Table'[Participant],"; ")Best Regards,
Community Support Team _ Eason
2 Replies
- v-easonf-msftCommunity Support
Hi, Chewbaklava
Please try formula like
Participants = CONCATENATEX(FILTER('Table','Table'[ID]=MAX('Table'[ID])),'Table'[Participant],"; ")Best Regards,
Community Support Team _ Eason - HotChilliCommunity Champion
Keep it simple.
Check out the example here
https://learn.microsoft.com/en-us/dax/concatenatex-function-dax