Concatenate date and time from different columns in one column in power bi Desktop

[Anonymous]

I'm trying to concatenate date and time from different columns in one column in power bi Desktop but i don't known how to do that.
In excel is very simple only i need sum the two columns, por example a1 + b1 where a1 is the date and b1 is the time

Thanks by the help

[camargos88 · Accepted solution]

Hi @Anonymous ,

Try this one for a calculated column:

DateTime = 'Table 2'[Date] & " " & TIME(HOUR('Table 2'[Time]); MINUTE('Table 2'[Time]); SECOND('Table 2'[Time]))

After it just change the DataType to Date/Time on Column Tool tab

[MarcoPessina · Accepted solution]

Hi @Anonymous ,

you can try this:

It works if you have a source table like this:

Hope it helps.

Cheers,

Marco

[armchairexpert]

Hi Marco,

It really did help.

Thanks

[camargos88 · Accepted solution]

Hi @Anonymous ,

Try this one for a calculated column:

DateTime = 'Table 2'[Date] & " " & TIME(HOUR('Table 2'[Time]); MINUTE('Table 2'[Time]); SECOND('Table 2'[Time]))

After it just change the DataType to Date/Time on Column Tool tab

[lyndaGough]

Hi

I am very new to PowerBi and I just tried your forumla, it works but I had to make a slight adjustment.

In your answer you are using " ; " between the time periods, PowerBi didn;t like that when I tried it but it worked when I used " , " instead.  Not sure if theis is change in PowerBi or typo in your response.  

Kinds regards