DAX to remove duplicates from comma separated string

[vaishnaviudan]

Hi, 

I have input like below

want to write a dax which will show below output:

Note: Need solution in PowerBI Desktop only not in Power Query Editor(Advance Editor).

[Zang_Mi]

Hello @vaishnaviudan and @marksn, there is an article with the solution using DAX: Removing Duplicates and Sorting Delimited Strings in Power BI .

[marksn]

This is brilliant! Thank you for sharing 🙂

[marksn]

is this still not possible in DAX?
I too have a calculated dax column that spits "abc; def; ghi; abc" and i want to get rid of duplicates (and at the same time sort it alphabetically).

[Ashish_Mathur]

Hi,

This is still not possible in DAX.  You will have to use Power Query to solve the question.

[Anonymous]

Hi @vaishnaviudan ,

As far as I know, this is currently not possible with DAX, you can try to implement it in Power Query.

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.