Forum Discussion
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 ...
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
Thank you Anonymous for you response, however i haven't been able to pair values function as you suggested with my filter function. I am enclosing a link to the file. Thanks.
Gop01
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
It works. Thank you so much.
Morning! So how would you do this if you need to filter things out based on another table?
