Calculating Due Date for an Issue

Questions & Answers
1

I would like to calculate the due date for an issue, based on the last sprint it appeared in and the estimated time for the issue. wonder if anyone can help. thanks

2

Hi @ArielR

If you have individual issues in Rows, you can define a new calculated measure in the Measures dimension with a formula that will check the start date of the current sprint that the issue has and, using the DateAddWorkdays function, add the estimated work hours to the sprint start date to determine the possible due date of the issue:

DateAddWorkdays(
  [Sprint].[Sprint].GetMemberByKey(
    [Issue].CurrentHierarchyMember.get('Sprint ID')
  ).Get('Start date'),
  [Measures].[Issue Original estimated hours] / 8
)

​Let me know if this fits your use case or if you have any additional questions on this!
​Best regards,
​Nauris