How to calculate an End date from a Start date and duration in hours in Power Bi Desktop?

[PamWren]

HI,

i have a report which gives start date and time also hours to complete.  How do I add a new column which gives me the end date and time based on these two columns?

I have tried a custom column with duration and all it does is returns an error.  The result needs to show the date and time 10 hours later that the creation date.

Thanks

[PamWren]

Thank you - it gives an end date but not a time.  But it will work for what I need I beleive.

[Anonymous · Accepted solution]

Hi, please do this as a calculated column:

NewDateTimeColumn = DateTimeColumn + TIME(TimeToResolution/Cancellation (Hours), 0, 0)