Group By and Concatenate

[Anonymous]

 

Hi, I need to group by Customer and get the clerk's concatenate (like it)

But when I grouped by, Power Bi returns me it (The number of clerk's by the following customer) 

Could someone help me please?

[PattemManohar]

@Anonymous Please try this..

Test163Out = SUMMARIZE(Test163Concat,Test163Concat[Customer],"Clerk",CONCATENATEX(Test163Concat,Test163Concat[Clerk]," "))

[Anonymous]

[v-piga-msft]

Hi @Anonymous,

You should create calculated table with the formula from PattemManohar, then you will get the dedired output.

Best Regards,

Cherry

[Anonymous]

It works, but the names are appearing more than once. I wish that each name appeared only one time in the line.

[v-piga-msft · Accepted solution]

Hi @Anonymous,

Please change your the formula like below.

Test163Out =
SUMMARIZE (
    Test163Concat,
    Test163Concat[Customer],
    "Clerk", CONCATENATEX ( VALUES ( Test163Concat[Clerk] ), Test163Concat[Clerk], " " )
)

And then you will get the output you desired.

Best Regards,

Cherry

[AlB]

Hi @Anonymous

What code did you use to get the results you mention?