Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Seperate date and time

Hi,   how do i seperate the date and time from the column ? I try to delimiter them and i can change the data type of date to date but not the time.  
Need Help
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

 

Thanks for helping.

 

I am relatively new in Power BI.

i paste the entire code into ''Advance editor in power query' and then this happened.

it did what it suppose to do split date and time but only 1 line remaining in the table

 

v-joesh-msft's avatar
v-joesh-msft
Icon for Solution Sage rankSolution Sage
6 years ago

Hi Anonymous ,

You can try using the Column From Examples in Query Editor. Enter the relevant data in the format you want, and Column From Examples will automatically match the format you want.

Here is a demo, refer to the APPLIED STEPS:

https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EeWoyemkIwtDnb1yOsm-Dz8BVW_1U9OKrlBKGOq9L3MfCw?e=7cq0hF

Best Regards,

Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.