Date + Duration

[Uspace87]

Hi all,

I need to add a duration to a date like in the example below:

Can anyone help?

[v-yinliw-msft · Accepted solution]

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]

@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]

Hi,

Thanks for the replay.

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