Calculating Remaining Days in Sprint

Questions & Answers
1

Is there an easy way to Calculate Days Remaining in a Sprint and multiply it by typical work day (say 8 hours) to get “where a team member” should be with hours?

Thank you,

2

Hi @Kikiriki,

Yes, you can calculate how many working days remain till the end of a sprint and then multiply the count of days with the number of working hours per day.

The calculation might look like this:

CASE WHEN --sprint is active
  [Sprint].CurrentHierarchyMember.get('Status') = "Active"
THEN --remaining working days until the planned sprint end date
  DateDiffWorkdays(
    Now(),
    [Measures].[Sprint end date]
  )
  --multiply with planned working hours per day
  * 8
END

Please set measure formatting to #,### Integer.

Best,
Zane / support@eazyBI.com