I am trying to sum up the completed story points of the last three sprints starting with the current sprint. For example, if a team has 15 points for sprint 7, 12 for sprint 6, and 11 for sprint 5, I would like to know the total of that number. I am using the following calculated member -
– filter last 3 closed sprints starting from current sprint
Cache(ChildrenSet([Sprint].[All closed sprints])),
Cache(ChildrenSet([Sprint].[All closed sprints]))
– only sprints with committed story points are retrieved
[Measures].[Sprint Story Points committed] > 0
[Measures].[Sprint Story Points completed]
If I change it to look for just 1 sprint (changing 3 to 1) it comes back with the latest closed sprint points correctly. When I change it to 2 or 3 I get numbers that do not seem to correlate to any of the story points for any of the sprints. It could be I am not using the calculation properly. Perhaps someone could show me where I am wrong.