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

[Anonymous]

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

[v-lili6-msft · Accepted solution]

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