if today is between two dates of sprint number then return value of sprint number in PowerBi DAX

[Samba777]

Hi Folks,

I have a sample data like belwo chart

Iteration Start Date	End date	Sprint number
12/27/2022	12/30/2022	41
12/28/2022	12/31/2022	41
12/29/2022	1/1/2023	41
12/30/2022	1/2/2023	41
12/31/2022	1/3/2023 0	42
1/1/2023	1/3/2023	42
1/2/2023	1/3/2023	42
1/3/2023	1/3/2023	42

Suppose today date is 27th dec, so i have get the sprint number is 41 and suppose date is jan1st 2023 then we need to get sprint number is 42.

Please help me with DAX

[tamerj1 · Accepted solution]

Hi @Samba777 
Please try

Today Sprint =
MAXX (
    FILTER (
        ALL ( Data ),
        Data[Iteration Start Date] <= TODAY ()
            && Data[IEnd Date] >= TODAY ()
    ),
    Data[Sprint]
)