Calculate end date column from start date and length

[Anonymous]

Please, how to calculate end date column if known only start date and length of the event in seconds? 

ISSUE_KEY	START_DATE	FROM_STATE	STATE	IN_STATE	END_DATE
A	24/09/2019 07:14	Estimation	In Progress	2
B	21/05/2019 21:25	Draft	Open	56987
C	20/02/2018 12:13	In Progress	Review	8899965
D	27/02/2019 09:38	Open	Definition	65
E	24/09/2019 17:15	Ready for Development	In Progress	4

[amitchandak]

@Anonymous , use dateadd

As a new column

end date = dateadd([start date], [add second],second)

https://docs.microsoft.com/en-us/dax/dateadd-function-dax

[Anonymous]

I am getting error: The last argument must be one of these keywords: DAY, MONTH, QUARTER, or YEAR.

So there is no other way to do that unless length column convert to days?

[Anonymous]

and when the length column (IN_STATE) recalcualte to days, I am getting another error: A date column containing duplicate dates was specified in the call to function 'DATEADD'. This is not supported.

[Anonymous]

So far I was able to solve it only via workaround in Power Query Editor, by adding two custom columns - one for converting the length in socnds to whole days (decimal number is not acceptet in Date.AddDays formula; and the second for adding end date using Date.AddDays. But this solution is not precisie to seconds. 

[mahoneypat · Accepted solution]

You can add a custom column with this formula to get your desired result (assume [Start Time] is DateTime format.

=[START_DATE] + #duration(0,0,0,[IN_STATE])

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat