I want to show only the last closed sprint and used below MDX but I am getting last 5 sprints instead of only last closed sprint.
NOT IsEmpty([Sprint].CurrentMember.get(‘Complete date’))),
Kindly help in correcting above MDX.
Please use this report to find our recommended formula for the last x closed sprints:
In your case for very last closed sprint it would be the following code:
1) --1 mean first member from a sorted tail
And there is one more report where you could filter the report sprints by board
Martins / eazyBI support