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

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

    Thank you!!!

    I could do this in Power BI.