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
Here is my data in powerbi, i would to see either split the multiple worknotes in the same field into multiple column, or split it into multi row. However if it is multi row, the assigned to has to repeat, Also, one could have no worknotes, one could have one worknote, and could have 2,3,4,5 or more
I found a solution, but it might be a bit fragile. It relies on (Work notes) being at the end of the line that defines a new entry.
Here is a report which shows how it can be achieved: report
Much appreciated. But it still not I wantðŸ˜
Then perhaps explain exactly what you want to achieve by using excel, and post a screenshot?
Yes, here is my data
What I want to see:
Thanks for all your effort
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
Thank you so much, that is exactly what I was looking for. Much Appreciated.