Forum Discussion
Date + Duration
Hi all,
I need to add a duration to a date like in the example below:
Can anyone help?
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.
3 Replies
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.
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
Hi,
Thanks for the replay.
I have tried to add these two columns in Power query but I can't:
