Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

CONCATENATEX AND VALUES RETURNING WRONG VALUES

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:
 
 
And i need to get something like this:
 
 
Could someone help me please?
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    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

2 Replies

  • AlB's avatar
    AlB
    Community Champion
    7 years ago

    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?

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    7 years ago

    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