My data exports with time and date combined in a cell - how do I analyze seperately

[PowerBI-Curious]

Hi

My time and date data exports in one cell "31/03/2017 4:06:07 pm". I need to analyze these seperately i.e. date in one graph and time in another.

Any help appreciated (brand new)

Thanks

PowerBI-Curious  

[Anonymous · Accepted solution]

One quick solution would be to create 2 new columns that are the same data as the DateTime column, then make use of the Data Formating to convert one to Time only and the other to Date only.

[PowerBI-Curious]

Thanks, I just did this 🙂 it worked a treat!