Filter your eazyBI for last 5 closed sprints

Bryan_Rosenthal · February 7, 2020, 9:38pm

So this is what I currently am working with. I have the correct sprints coming through, I just can not figure out how to order them chronologically by date. I am using this in the sprint member:

Aggregate(
  Filter([Sprint].[Sprint].Members,
    NOT IsEmpty([Sprint].CurrentMember.get('Start date')) AND 
    DateBetween(
      [Sprint].CurrentMember.get('End date'),
      '12 weeks ago',
      'Now') AND
    ([Sprint].CurrentMember.Name MATCHES '^EPSS Sprint.*' OR
    [Sprint].CurrentMember.Name MATCHES '^EPC Sprint.*')
  )
))