Splitting a group of text/date in a single column to multiple rows

[Anonymous]

All,

Probably this comes under data pre-processing. I wanted to know what kind of technique to use and to get some similar solution as in the output table on the image. 

(I also wanted the text 'TIME' to be excluded before spilitting the row)

Any suggestion is welcome.

Thank you in advance.

Regards,
Harish Dhanarajan

[Anonymous]

There may be a fancy way of doing it, but here is how I would do it.

(Be aware, this process will remove the initial column, if you want to keep it - duplicate it and then work with the new one)

Within Edit Queries there's an option to 'Split Columns', I would split by delimeter (the comma) to give you 3 columns. You'll then need to split the first new column again to remove TIME. This will give you 4 new columns in total, you can simply delete the one with TIME.

Format your fields so PowerBi recognises them as a date.
If you want the final view, youll then need to pivot the data.

Hope this makes sense.

[Anonymous]

Thank you for the solution. I can try your solution but the problem is that I do not have the actual data source, so the edit query option wouldn't work.  However, I can view the data, create measure, create calculated fields and visualise them. 

---

@Anonymous wrote:

There may be a fancy way of doing it, but here is how I would do it.

(Be aware, this process will remove the initial column, if you want to keep it - duplicate it and then work with the new one)

Within Edit Queries there's an option to 'Split Columns', I would split by delimeter (the comma) to give you 3 columns. You'll then need to split the first new column again to remove TIME. This will give you 4 new columns in total, you can simply delete the one with TIME.

Format your fields so PowerBi recognises them as a date.
If you want the final view, youll then need to pivot the data.

Hope this makes sense.

---