https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculated-column/m-p/2330847#M58567 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="267792" data-lia-user-login="DagdasAlbag" class="lia-mention lia-mention-user">DagdasAlbag</a> , try like </P> <P>&nbsp;</P> <P><BR />Rollierende Monate =<BR />VAR ytdmonths = format(TODAY(), "MMDD")<BR />RETURN<BR />IF(format(Kalendertabelle[Date], "MMDD") &lt;= ytdmonths,1,0)</P> Thu, 10 Feb 2022 12:36:25 GMT amitchandak 2022-02-10T12:36:25Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculated-column/m-p/2330843#M58566 <DIV><DIV><SPAN>how can I turn rolling months into rolling days?<BR />the formula refers to rolling months: </SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Rollierende Monate = </SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>ytdmonths</SPAN><SPAN> = </SPAN><SPAN>MONTH</SPAN><SPAN>(</SPAN><SPAN>TODAY</SPAN><SPAN>())</SPAN></DIV><DIV><SPAN>RETURN</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>Kalendertabelle[Monat_kurz]</SPAN><SPAN> &lt;= </SPAN><SPAN>ytdmonths</SPAN><SPAN>,</SPAN><SPAN>1</SPAN><SPAN>,</SPAN><SPAN>0</SPAN><SPAN>)</SPAN></DIV></DIV> Thu, 10 Feb 2022 12:31:57 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculated-column/m-p/2330843#M58566 DagdasAlbag 2022-02-10T12:31:57Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculated-column/m-p/2330847#M58567 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="267792" data-lia-user-login="DagdasAlbag" class="lia-mention lia-mention-user">DagdasAlbag</a> , try like </P> <P>&nbsp;</P> <P><BR />Rollierende Monate =<BR />VAR ytdmonths = format(TODAY(), "MMDD")<BR />RETURN<BR />IF(format(Kalendertabelle[Date], "MMDD") &lt;= ytdmonths,1,0)</P> Thu, 10 Feb 2022 12:36:25 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculated-column/m-p/2330847#M58567 amitchandak 2022-02-10T12:36:25Z