Forum Discussion

Uspace87's avatar
Uspace87
Icon for Resolver III rankResolver III
3 years ago
Solved

Date + Duration

  Hi all,   I need to add a duration to a date like in the example below:         Can anyone help?
Need Help
  • v-yinliw-msft's avatar
    v-yinliw-msft
    3 years ago

    Hi Uspace87 ,

     

    You can try this method:

    In Power Query, add a custom column:

     

    Hope this helps you.

    Here is my PBIX file.

     

    Best Regards,

    Community Support Team _Yinliw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Uspace87 , In power query if they datetime and duration add them 

 

i tried static code and it worked

#datetime(2022,01,01,0,0,0) + #duration(1,1,0,0)

 

[Order Createdon] + [Duration]

 

In DAX make them both datetime and add 

  • Uspace87's avatar
    Uspace87
    Icon for Resolver III rankResolver III
    3 years ago

    Hi,

     

    Thanks for the replay.

     

    I have tried to add these two columns in Power query but I can't: