How to add 1 day to the date of sprint start?


How can I add 1 day to the calculated member below that counts how many stories are committed for sprint?

( [Measures].[Story Points added],
[Transition Field].[Sprint status],
[Sprint Status].[Active],
– An issue was in a sprint at a sprint start time
[Issue Sprint Status Change].[Future => Active],
[Sprint].CurrentMember.get(‘Start date’) – want to add 1 day here

The problem is that when the sprint is opened some stories are not yet cleared/moved to next sprint in Jira so in the commited stories I can see stories that were moved to the next sprint on day when the sprint was opened.

Thank you for your hints


You could try using DateAddDays or DateAddWorkdays function to add days
See more details here:

Try this code to return the story points at the next day after sprint started

[Measures].[Story Points history],
    [Sprint].CurrentMember.get('Start date'),1

Best regards,
Martins / eazyBI team

Many thanks Martins.

Unfortunately it does not work.
The whole formula returns 0 when I am adding something different than 0 (e.g. 1 day).


You are right, that code I posted earlier was not useful, so I edited my original answer.
In this case you could try using the measure “Story points history” together with a “Time” dimension member.
See the code above!

Thanks for the feedback.

The new formula works fine, thank you.