Power query - add time to date

[wannes]

I have a column with a date and a column with a time. Ie: 11/27/2016 | 11:48:14
I want to add a column that contains the sum of the date and the time: 11/27/2016 11:48:14.
What would be the best syntax to perform that?

Thanks!

 

[Ken Puls]

One way:

Use the following formula in a Custom Column:
DateTime.From(Text.From([DateColumn])&" "&Text.From([TimeColumn]))