CONCATENATEX AND VALUES RETURNING WRONG VALUES

[Anonymous]

I am using this formula: 

Table = SUMMARIZE('CUSTOMER-S&OP';'CUSTOMER-S&OP'[Customer Name];"S&OP";CONCATENATEX(VALUES('S&OP''S'[S&OP]);'S&OP''S'[S&OP];""))

I need to get te Custommer and the S&OP'S (LIKE CLERK'S) responsable for they.

But, by any reason, it doesn't works, it returns all S&OP'S, i want something like this:

 https://uploaddeimagens.com.br/imagens/capture-png-8cf9ec79-5696-4288-8db9-e7b6a7068187/mostrar-codi...

And i need to get something like this:

https://uploaddeimagens.com.br/imagens/capt2-png

Could someone help me please?

[v-cherch-msft · Accepted solution]

Hi @Anonymous

You may refer to below fomular. But it's better that if you could share your sample data which could reproduce your scenario and your desired output.

Table1 =
SUMMARIZE (
 Table,
 Table[Customer Name],
 "S&OP", CONCATENATEX (
 FILTER (
 VALUES ( Table[S&OP] ),
 Table[Customer Name] = EARLIER ( Table[Customer Name] )
 ),
 Table[S&OP],
 ","
 )
)

Regards,

Cherie

[AlB]

Hi @Anonymous

Can you show the pbix? Or at least show the structure and relationships of your tables?

From what I see,  the [Customer Name] and [S&OP] columns are in different tables?