Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

To remove duplicate char from string on each row using DAX expression

Hi All, Need your help to remove duplicate chars from string using DAX expression. I have used the CONCATENATEX function to concatenate rows values based on some criteria. Due to this my string in ...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

    Please update the formula of calculated column [sousOF_] as below and check if that is what you want. You can find the details in the attachment.

    sousOF_ = 
CONCATENATEX (
    FILTER (
        VALUES ( Ds[ID] ),
        PATHCONTAINS ( [Lien], EARLIER ( [ID] ) )
            && VALUE ( [ID] ) >= VALUE ( EARLIER ( Ds[ID] ) )
    ),
    [ID]
)

    Best Regards

mariussve1's avatar
mariussve1
Solution Sage
3 years ago

Hi,

 

Could you try to use DISTINCT(), like:

CALCULATE(CONCATENATEX(DISTINCT('table'[column]);'table'[column];", "))

 

Br

Marius