Get current sprint from a particular board

Hello,

I’m attempting to get the most current sprint from a particular sprint board into a calculated member, however after reading this post: Automatically select current sprint I’m still unable to do it as it gets all boards, I’d like just a paricular board, to which I supply by name.

I’ve attempted to do things such as:

Aggregate(
  {
    [Sprint].[Aardvark Sprints].Members
    NOT [Sprint].CurrentMember.GetBoolean('Closed')
  }
)

but that just breaks the report. Any assistance would be highly appreciated.

Hi,

you should apply the Children function to the board level member to have the full set of sprints in a specific board:

Aggregate(
  Filter([Sprint].[My board].Children,
  NOT [Sprint].CurrentMember.GetBoolean('Closed'))
)

Kindly,
Janis, eazyBI support