Forum Discussion

Chewbaklava's avatar
Chewbaklava
Frequent Visitor
3 years ago
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.

 

IDParticipant
001John
001Terry
001Albert
002Susan
002Roger
003Sally
003Tom
003Chewbaklava


Participants Conc = CALCULATE(CONCATENATEX(table, <expression>, "; ")

 

I'm struggling with the expression piece.

My visual will have columns: ID & [Participants Conc]:

IDParticipants Conc
001John; Terry; Albert
002Susan; Roger
003Sally; Tom; Chewbaklava


Thanks for any suggestions or advice

2 Replies