Calculating Remaining Days in Sprint

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,

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
    [Measures].[Sprint end date]
  --multiply with planned working hours per day
  * 8

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

Zane /