Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Split by delimeter

Hi, 

Are there any ways in DAX or Power Query for me to seperate names with slash at the delimeter. The column in my table looks like this:

 

I want it to be like:

 

Thanks in advance!

 

 

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

    In Power Query, you can achieve it if you split column as shown below-

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

    In Power Query, you can achieve it if you split column as shown below-

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks so much! Funny how I didnt see that i have the option to split into rows