compare today date with multiple dates in power bi DAX

[Samba777]

Hi Folks,

Here is the table info,

Date	SprintNo
9/1/2022 0:00	37
9/2/2022 0:00	38
9/3/2022 0:00	38
9/4/2022 0:00	39
9/5/2022 0:00	39

I want to get the Sprint Number if it is today date, Expected result today is 37.

If today date is 9/2/2022, then result would be 38.

Can anyone please help me about the DAX query.

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

[Samba777]

Thanks for the provided solution, This works for my requirement.