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 single cell becomes as per below:
Output String using CONCATENATEX function:
123333333333333333455555555555555567
Expected result:
1234567
I want to remove duplicate char from my string on each row. Ihave tried insert values function inside CONCATENATEX like : CONCATENATEX(table,values(filter(..)),filter(..)) . But no success.
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
6 Replies
Hi,
Could you try to use DISTINCT(), like:
CALCULATE(CONCATENATEX(DISTINCT('table'[column]);'table'[column];", "))
Br
Marius
Hi Anonymous ,
You can refer the following links to remove the duplicated values when using CONCATENATEX function:
CONCATENATEX is providing duplicated result even when using values() ,distinct() or related table()Measures=
CONCATENATEX (
VALUES ( '# test_DRIVER_DASHBOARD'[CATEGORY] ),
'# test_DRIVER_DASHBOARD'[CATEGORY],
","
)CONCATENATEX providing unique (distinct) values
If the above ones can't help you get the expected result, please provide some raw data in the table 'Ds' with Text format and the calculation logic of the calculated column [sousOF_]. It seems that you used PATHCONTAINS function there, is there any hierarchy level exist in the field? It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
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
