Forum Discussion
Remove duplicates in values (string)
Hello,
I have in a column, values including some duplicates :
Ex :
Input :
| ID | Value |
| ID1 | A-B-A-C-A |
| ID2 | A-B |
| ID3 | A-C-C |
Expected Output :
ID | Value |
| ID1 | A-B-C |
| ID2 | A-B |
| ID3 | A-C |
Thanks in advance for your help
Hi Anonymous ,
Please refer to my pbix file to see if it helps you.
Create a custom column in Power Query.
=Text.Combine ( List.Distinct( List.Transform (Text.Split([Value],"-"),each Text.Trim(_)) ) ,"- ")Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Anonymous Use Text to Table, replace - with | see the first comment below this entry:
Text to Table - Microsoft Power BI Community
Then you can use DISTINCT and CONCATENATEX to recombine with your dashes.
Hi Anonymous ,
Please refer to my pbix file to see if it helps you.
Create a custom column in Power Query.
=Text.Combine ( List.Distinct( List.Transform (Text.Split([Value],"-"),each Text.Trim(_)) ) ,"- ")Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
