Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

DAX Formula to separate comma separated values within a column cell.

I have a field "RPT_VERT_SKEY" that has comma separated values. The count of comma separated values is also not same for all the cells of field "RPT_VERT_SKEY".

 

How it is possible to extract the comma separated values from "RPT_VERT_SKEY" field.

 

RPT_VERT_SKEY: 1,2,3,4.... so on

 

Need Help

3 Replies

  • PattemManohar's avatar
    PattemManohar
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Anonymous  Did you tried the "Split Column" option available in "Power Query Editor". That will solve your problem.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Manohar,

       

      I'm not using Power Query Editor here. I'm trying to implement it in SSDT.

      • PattemManohar's avatar
        PattemManohar
        Icon for Community Champion rankCommunity Champion
        7 years ago

        Anonymous Oh ok, that means you are trying to implement this in SSAS or SSIS using SQL Server Data Tools (SSDT) ?