https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/if-today-is-between-two-dates-of-sprint-number-then-return-value/m-p/2990001#M100552 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="435811" data-lia-user-login="Samba777" class="lia-mention lia-mention-user">Samba777</a>&nbsp;<BR />Please try</P> <LI-CODE lang="javascript">Today Sprint = MAXX ( FILTER ( ALL ( Data ), Data[Iteration Start Date] &lt;= TODAY () &amp;&amp; Data[IEnd Date] &gt;= TODAY () ), Data[Sprint] ) </LI-CODE> Tue, 27 Dec 2022 11:22:10 GMT tamerj1 2022-12-27T11:22:10Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/if-today-is-between-two-dates-of-sprint-number-then-return-value/m-p/2989972#M100550 <P>Hi Folks,</P><P>I have a sample data like belwo chart</P><TABLE><TBODY><TR><TD>Iteration Start Date</TD><TD>End date</TD><TD>Sprint number</TD></TR><TR><TD>12/27/2022&nbsp;</TD><TD>12/30/2022&nbsp;</TD><TD>41</TD></TR><TR><TD>12/28/2022&nbsp;</TD><TD>12/31/2022&nbsp;</TD><TD>41</TD></TR><TR><TD>12/29/2022&nbsp;</TD><TD>1/1/2023&nbsp;</TD><TD>41</TD></TR><TR><TD>12/30/2022&nbsp;</TD><TD>1/2/2023&nbsp;</TD><TD>41</TD></TR><TR><TD>12/31/2022&nbsp;</TD><TD>1/3/2023 0</TD><TD>42</TD></TR><TR><TD>1/1/2023&nbsp;</TD><TD>1/3/2023&nbsp;</TD><TD>42</TD></TR><TR><TD>1/2/2023&nbsp;</TD><TD>1/3/2023&nbsp;</TD><TD>42</TD></TR><TR><TD>1/3/2023&nbsp;</TD><TD>1/3/2023&nbsp;</TD><TD>42</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>Please help me with DAX</P> Tue, 27 Dec 2022 10:55:45 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/if-today-is-between-two-dates-of-sprint-number-then-return-value/m-p/2989972#M100550 Samba777 2022-12-27T10:55:45Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/if-today-is-between-two-dates-of-sprint-number-then-return-value/m-p/2990001#M100552 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="435811" data-lia-user-login="Samba777" class="lia-mention lia-mention-user">Samba777</a>&nbsp;<BR />Please try</P> <LI-CODE lang="javascript">Today Sprint = MAXX ( FILTER ( ALL ( Data ), Data[Iteration Start Date] &lt;= TODAY () &amp;&amp; Data[IEnd Date] &gt;= TODAY () ), Data[Sprint] ) </LI-CODE> Tue, 27 Dec 2022 11:22:10 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/if-today-is-between-two-dates-of-sprint-number-then-return-value/m-p/2990001#M100552 tamerj1 2022-12-27T11:22:10Z