Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

DAX to remove duplicates from comma separated string

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).
Need Help
marksn's avatar
marksn
Frequent Visitor
2 years ago

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's avatar
    Ashish_Mathur
    Super User
    2 years ago

    Hi,

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