Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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