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&...
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

v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft 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