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

Questions & Answers
1

Hello,

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],
[Time].CurrentHierarchy.Levels(‘Day’).DateMember(
[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

2

Hi,

You could try using DateAddDays or DateAddWorkdays function to add days
See more details here:
https://docs.eazybi.com/display/EAZYBI/MDX+Function+Reference#MDXFunctionReference-DateFunctions

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

(
[Measures].[Story Points history],
[Time].CurrentHierarchy.Levels('Day').DateMember( 
  DateAddDays( 
    [Sprint].CurrentMember.get('Start date'),1
  )
 )
)

Best regards,
Martins / eazyBI team

3

Many thanks Martins.

4

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

5

Hi,

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.

6

The new formula works fine, thank you.