# Filter your eazyBI for last 5 closed sprints

**URL:** <https://community.eazybi.com/t/filter-your-eazybi-for-last-5-closed-sprints/2099>\
**Category:** Tips & Tricks\
**Tags:** sprints\
**Created:** [April 29, 2019, 1:01pm UTC](https://community.eazybi.com/t/filter-your-eazybi-for-last-5-closed-sprints/2099 "2019-04-29T13:01:14Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![Bryan\_Rosenthal](https://community.eazybi.com/user_avatar/community.eazybi.com/bryan_rosenthal/32/2365_2.png) [@Bryan\_Rosenthal](https://community.eazybi.com/u/Bryan_Rosenthal)\
**Post date:** [February 7, 2020, 9:38pm UTC](https://community.eazybi.com/t/filter-your-eazybi-for-last-5-closed-sprints/2099/4 "2020-02-07T21:38:47Z")

</div>

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.*')
  )
))

```

 ![Screen Shot 2020-02-07 at 4.30.14 PM](https://community.eazybi.com/uploads/default/original/2X/3/37bc67d2d4a36d4d377d2ed331dcf9bfeaa0edb8.png)

---

_[View the full topic](https://community.eazybi.com/t/filter-your-eazybi-for-last-5-closed-sprints/2099)._