Forum Discussion

PedroF's avatar
PedroF
New Member
4 years ago
Solved

How to sum Date with Time?

Hi all, 

 

I am working on a calendar model on power BI and on my database I have two columns:

one with the date and another one with the time (which is my deadline)

I would like to merge both in order to have the date also with time information

 

I have done that on excel just summing up both information and it works, but not for power bi. Does somebody know how to do it?

 

example:

 

Column Date.       Column Time

01/01/2022.             17:00

--------------------------------------

Desired result

 

Column Date & Time

01/01/2022 17:00

1 Reply

  • PedroF 

    pls try to create a column

    = Date+ Time

    and change the column to datetime type