Forum Discussion
Split field into multiple column
Perfect. In retrospect, those two screenshots is what you should have posted in your first post 😉
Also, my bad on the report I uploaded, I somehow must not have saved the last version I was working with.Try this instead: https://www.dropbox.com/s/fw81h93f73mi47m/Split%20field%20into%20multiple%20column2.pbix?dl=0
Hi, Yucy
this could solved by using the Split-function in Power Query/Advanced editor in Power BI. The first split is pretty simple, if all your values are formatted the same way. Split on the right most occurence of "-".
The second split is a bit more tricky, because you have to handle a new line(either Line feed or carriage return or both). Here is a description of how to do it: excelguru.ca/blog/2015/10/16/split-by-line-breaks/
Cheers,
Sturla
If this post helps, then please consider Accepting it as the solution. Kudos are nice too.
Go to edit query -> Split column -> give delimiter there and then close and apply.
YOu will have your required columns.
Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar
If I resolve your problem Mark it as a solution and give kudos.