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 advanc...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

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

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

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

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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