NextStartDate
EAZYBI Returns the next date after the end date of this time period.
Syntax
Time_Member_Expression.NextStartDate
Arguments
| Time_Member_Expression | MDX expression that returns the time dimension member. |
|---|
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.
DateDiffWorkdays(
DateWithoutTime([Sprint].CurrentMember.get('Activated date')),
[Time].CurrentHierarchyMember.NextStartDate
)
The formula above 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.