How to calculate a measure using a date column?

[Anonymous]

Hi, I have a dataset like this. There are only two sprints in one month, the first one starts on 1st day of the month and end by the 14th whereas the second one starts by 15th and ends by 30 th.

Sprint     Story      Date Created(mm-dd-yyy)

AA          1             1/1/2021

AA          2             1/2/2021

AA          3              1/7/2021

BB          4              1/15/2021

BB          5              1/18/2021

BB          6              1/22/2021

I want to calculate the total count of stories(measure) for the first 3 days of each sprint, which means between Day 1-3 whenever we are in first sprint and the first 3 days for the second sprint(day 15-18) whenever we are in the second sprint, regardless of the month and year . Any thoughts?

The expected outcome should be

Sprrint AA count- 2 stories

Sprint BB Count- 2 stories

[Greg_Deckler · Accepted solution]

@Anonymous Well, you could get the minimum day for a sprint using MINX(FILTER(...),...) and then you could get the upper range by taking that variable and adding 3. Then you could filter the table by that range > min && < max.