Forum Discussion

ppgandhi11's avatar
ppgandhi11
Icon for Helper V rankHelper V
7 years ago
Solved

DAX formula help comma separated list

Hi, I have a list such as:   Provider    Specialties A                 AB, BC, CD B                 AB C                 BC D                 CD, DE   From above, I want to generate a list li...
Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi ppgandhi11,

    Based on my test, you could refer to below steps:

    Sample data:

    Split teh [Special] column by ",":

     

    Unpivot all the column except the [provider] column:

    Remove the extra column, now you can see the result:

    You could also download the pbix file to have a view.

     

    Regards,

    Daniel He

     

v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi ppgandhi11,

Based on my test, you could refer to below steps:

Sample data:

Split teh [Special] column by ",":

 

Unpivot all the column except the [provider] column:

Remove the extra column, now you can see the result:

You could also download the pbix file to have a view.

 

Regards,

Daniel He