Forum Discussion

JuliaYebra's avatar
JuliaYebra
Icon for Helper III rankHelper III
10 years ago

Unify Date and Time columns into one DateTime column

Is it possible to unify a column which has a date with another column which has the time into one DateTime column?

 

 

Need Help

2 Replies

  • MattAllington's avatar
    MattAllington
    Icon for Community Champion rankCommunity Champion
    10 years ago

    Yes, but depending on what you are doing that may not be optimal.  separate columns compress better and hence you data model sill be smaller and faster.

     

    Just select both columns in Power Query, right click and then merge with a space separator.  Then convert to Date/Time