Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

To remove duplicate words from string on front end using DAX expression

Hi All,

Need your help to remove duplicate words from string on front end using DAX expression.

I have used the CONCATENATEX function to concatenate rows values based on some criteria. Due to this my string in single cell becomes as per below: 

Output String using CONCATENATEX function:

excruciating,misses,other contains,few,annoying,special,golden,few,feature 

Expected result:

excruciating,misses,other contains,few,annoying,special,golden,feature 

I want to remove duplicate word from my string on front end. 

 

Thanks,

Ani

  • HI, Anonymous 

    For your requirement, just adjust your formula as below:

    Use VALUES Function in CONCATENATEX expression.

    For example:

    Measure = CONCATENATEX(Table1,[Column1])
    Measure 2 = CONCATENATEX(VALUES(Table1[Column1]),[Column1])

    Result:

     

    Best Regards,

    Lin

1 Reply

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support

    HI, Anonymous 

    For your requirement, just adjust your formula as below:

    Use VALUES Function in CONCATENATEX expression.

    For example:

    Measure = CONCATENATEX(Table1,[Column1])
    Measure 2 = CONCATENATEX(VALUES(Table1[Column1]),[Column1])

    Result:

     

    Best Regards,

    Lin