How to combine different rows into a single row that belongs to same category ?

[Anonymous]

Hi Community,

Could some one please help me with the below requirement. I know how to do this in SQL using stuff function. However, with huge data i do not want to use STUFF function . I want to do this in power bi . 

Support i have a requirement like below : 

As the Server and serial no (first 2 columns) are same for 2 different app names and App Id's , i want the output to be like shown below. 

I usually do this in SQL using stuff function .However, i would like to do this in power bi going forward. Kindly assist. 

Thanks,

G Venkatesh 

[Anonymous]

Thanks for Providing the solution. I also want to provide a different method which i tried and worked. I used Summarize and created a new table . 

Concatenate values table =

SUMMARIZE( 'Servers', 'Servers'[Server Name],'Servers'[Serial#],

//We are grouping all Application details by Server Name //

"App ID", CONCATENATEX('Servers', 'Servers'[Application ID], ", "),

"App Name", CONCATENATEX('Servers', 'Servers'[Application Name], ", "))

[PaulDBrown]

You can do this by creating measures using CONCATENATEX. For example,

app name = CONCATENATEX(VALUES(Table[app name]), Table [app name], ", ")

[FrankAT · Accepted solution]

Hi @Anonymous ,

you can do it like this:

App ids = CONCATENATEX(VALUES('Table'[App id]), 'Table'[App id], ". ")

app names = CONCATENATEX(VALUES('Table'[app name]), 'Table'[app name],", ")

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)