Forum Discussion

ppgandhi11's avatar
ppgandhi11
Helper 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

     

Vvelarde's avatar
Vvelarde
Community Champion
7 years ago

ppgandhi11

 

Hi, In Edit Query

 

Select Your Column Specialties

 

Transform-Split Columns

 

Delimiter--> Comma

 

Advance Options--Split into Rows

 

Regards

 

Victor