Forum Discussion

aramirez2's avatar
aramirez2
Helper I
4 years ago
Solved

Clean duplicate words in a string using CONCATENATEX funciton

Hi.   I have a issue trying to concatenate strings.   My model contains 2 tables: Product and Component. Each product is built up by 2 or more components. Each component contains a label.   For...
Need Help
  • smpa01's avatar
    smpa01
    4 years ago

    aramirez2  you can use a measure like this

     

    Measure =
CONCATENATEX (
    VALUES ( Component[LABEL] ),
    Component[LABEL],
    ",",
    Component[LABEL], ASC
)

     

     

     

    If you need a calculated column

    Column =
CONCATENATEX (
    SUMMARIZE ( RELATEDTABLE ( Component ), Component[LABEL] ),
    CALCULATE ( MAX ( Component[LABEL] ) ),
    ",",
    Component[LABEL]
)

     

     

     

aramirez2's avatar
aramirez2
Helper I
4 years ago

Hi amitchandak  Thanks for your answer.

 

However your measure formula does not run due to the different component labels for a single Product:

 

 

Would it be possible to create a columns instead of a measure?

 

Thanks for your help.

 

Regards.

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    aramirez2 , do you have two tables? If yes, share sample data for both and sample output in table format