NextStartDate

Syntax

Time_Member_Expression.NextStartDate

Arguments

Examples

[Time].CurrentMember.NextStartDate when used with a month member, it will return the start date of the next month (with time 00:00:00), for a day member, it will return the start date of the next day, and so on.

[Time].CurrentMember.NextStartDate will return the same result as [Time].CurrentMember.NextMember.StartDate if the current Time member has a next member. But it is safer to use NextStartDate as it will return the next start date also for the last Time dimension member.

Elapsed workdays in sprint

This formula will calculate the workdays from Sprint actual start date till each date on a timeline (1 for the first day in the sprint, 2 for the second day in the sprint, etc.). The calculation is used within a default measure for Jira Software Sprint Story Points guideline. See it in the sample report Sprint story points burn-down in our demo account.

DateDiffWorkdays(
  DateWithoutTime([Sprint].CurrentMember.Get('Activated date')),
  [Time].CurrentHierarchyMember.NextStartDate
)

Total overdue issues at the end of the period

This formula calculates the number of issues that were in an "overdue" state at the end of a selected Time period. It provides a historical "snapshot" of the overdue backlog. Use quarters, months, or weeks in the report Rows to see the number of Overdue issues at the end of each period.

Count(
  Filter(
    Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
    -- Check if the Issue has a due date
    NOT IsEmpty([Measures].[Issue due date])
    AND
    -- Check that the due date is before the End current period
    -- End of period can be derived from the start date of the next period
    DateCompare(
      [Measures].[Issue due date],
      [Time].CurrentHierarchyMember.NextStartDate
    ) < 0
    AND
    -- Check that the resolution date is empty or after end of current period
    (
      IsEmpty([Measures].[Issue resolution date])
      OR
      DateCompare(
        [Measures].[Issue resolution date],
        [Time].CurrentHierarchyMember.NextStartDate
      ) >= 0
    )
  )
)

See also