Forum Discussion
Solved
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 ...
Hi, Chewbaklava
Please try formula like
Participants = CONCATENATEX(FILTER('Table','Table'[ID]=MAX('Table'[ID])),'Table'[Participant],"; ")Best Regards,
Community Support Team _ Eason
v-easonf-msft
Community Support
Community SupportHi, Chewbaklava
Please try formula like
Participants = CONCATENATEX(FILTER('Table','Table'[ID]=MAX('Table'[ID])),'Table'[Participant],"; ")
Best Regards,
Community Support Team _ Eason