How to combine text values of multiple rows into one row

[MandyL]

Hi,

I'm able to use the "Group By" function to summarize value, but not for Text.

The Data Source shows the same ID and support by multiple Users. May I know is there any way to show one row with multiple Users, like the Output Data below? Thanks!

Source Data

ID	User
ID1	User A
ID1	User B
ID1	User C
ID2	User D
ID2	User E

Output Data

ID	User
ID1	User A, User B, User C
ID2	User D, User E

Best regards,

Mandy

[amitchandak · Accepted solution]

@MandyL , Create a measure and use with ID

concatenateX( Table, Table[user] , ", ")

Refer three methods

https://youtu.be/xAh3tz1qo24

[MandyL]

It works. Thank you 😊