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
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.