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 ...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    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

v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

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