Selecting last sprint from Closed Sprint list

Questions & Answers
1

I am able to get a list of Closed sprints per Board/Project, but need to be able to select only the most recently closed Sprint for each.

image
image886Ă—506 43.9 KB

2

You need to generate an aggregation for it with the option of “Define new calculated member”
You can see the link inside the “Sprint” Dimension:

image
image1322Ă—586 39.8 KB

Add the name you want and the code of:

Aggregate(
  Generate(
  -- get all boards
    [Sprint].[Board].Members,
    -- access all children - sprints from the board and get the last closed
    Tail(
      Filter(
      [Sprint].CurrentMember.Children,
      [Sprint].CurrentMember.GetBoolean("Closed")),
      -- 1 last (from Tail) closed sprint from a board
      1)
      -- address the first (0) member from a set
      .Item(0)
  )
)