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

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

    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.

     

     

     

     

    • marksn's avatar
      marksn
      Frequent Visitor
      2 years ago

      This is brilliant! Thank you for sharing 🙂

  • 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.