Forum Discussion
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-msftCommunity 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