Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Hi, @Chewbaklava
Please try formula like
Participants = CONCATENATEX(FILTER('Table','Table'[ID]=MAX('Table'[ID])),'Table'[Participant],"; ")
Best Regards,
Community Support Team _ Eason
Hi, @Chewbaklava
Please try formula like
Participants = CONCATENATEX(FILTER('Table','Table'[ID]=MAX('Table'[ID])),'Table'[Participant],"; ")
Best Regards,
Community Support Team _ Eason
Keep it simple.
Check out the example here
https://learn.microsoft.com/en-us/dax/concatenatex-function-dax
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |