Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

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 exampl...
Need Help
Show and Tell
  • camargos88's avatar
    camargos88
    6 years ago

    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's avatar
    MarcoPessina
    6 years ago

    Hi Anonymous ,

    you can try this:

    It works if you have a source table like this:

    Hope it helps.

    Cheers,

    Marco

camargos88's avatar
camargos88
Icon for Community Champion rankCommunity Champion
6 years ago

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's avatar
lyndaGough
Frequent Visitor
5 years ago

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