Sprint goals per sprint between dates (for a release)

I am trying to create sprint goals report per sprint for a release. We release every quarter.
So, for example if the release is between Jan 1st and Mar 31st

Board| Sprint goal | Start Date | End Date
A | abc |01/01/2020|01/14/2020
A |xyz |01/15/2020|01/28/2020

A |fg |03/18/2020|03/31/2020
B |cde |01/01/2020|01/14/2020
B |fsa |01/15/2020|01/28/2020

A |fgds |03/18/2020|03/31/2020
So far, I have “All Sprints” selected on the Rows, “Sprint Goals” selected under Measures and displays for all the boards. How do I limit to show only sprints between a date range and limit to only boards A, B and C?
Thank you

Hi @jkrishnan,
welcome to eazyBI community! :slight_smile:

About your question - you may want to check our demo account where in the Sprint dimension you can find a calculated member Sprints closed between two dates. This measure shows you all sprints that have been completed between specific dates. You can change them accordingly to your needs.

      [Sprint].CurrentMember.getBoolean('Closed') AND
      NOT IsEmpty([Sprint].CurrentMember.get('Complete date')) AND
      DateBetween([Sprint].CurrentMember.get('Complete date'),
        '01 JUL 2016',
        'today') ),
    [Sprint].CurrentMember.get('Complete date'),

Gerda // support@eazybi.com