Power query - add time to date

wannes

New member
Joined
Dec 2, 2016
Messages
3
Reaction score
0
Points
0
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!
 
One way:

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