topic Re: Calculate with dates (30 days before) in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-with-dates-30-days-before/m-p/3176842#M114709 <P>hi @Anonymous</a>&nbsp;</P><P>try like:</P><DIV>Measure =</DIV><DIV>COUNTROWS(</DIV><DIV>&nbsp; &nbsp; FILTER(</DIV><DIV>&nbsp; &nbsp; &nbsp; &nbsp; TableName,</DIV><DIV>&nbsp; &nbsp; &nbsp; &nbsp; TableName[Date]&lt;TODAY()-30</DIV><DIV><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;)</SPAN></DIV><DIV><SPAN>)</SPAN></DIV> Thu, 06 Apr 2023 22:47:51 GMT FreemanZ 2023-04-06T22:47:51Z Calculate with dates (30 days before) https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-with-dates-30-days-before/m-p/3176701#M114698 <P>Hello,&nbsp;</P><P>&nbsp;</P><P>I need to do a measurement that calculates only what appears 30 days back, for example:</P><P>considering today(yyyy-mm-dd): 2023-04-06.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Date (yyyy-mm-dd):</TD><TD>After 30 days:</TD></TR><TR><TD>2023-03-15</TD><TD>Y</TD></TR><TR><TD>2023-01-28</TD><TD>Y</TD></TR><TR><TD>2023-04-01</TD><TD>N</TD></TR><TR><TD>2023-04-03</TD><TD>N</TD></TR><TR><TD>2023-03-20</TD><TD>N</TD></TR><TR><TD>Total</TD><TD>2</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>In this case i have 5 dates and only 2 dates are 30 days back. I need a measure that do this calculation.</P><P>&nbsp;</P><P>Anybody can help me?&nbsp;</P><P>&nbsp;</P><P>Thanks a lot.</P> Thu, 06 Apr 2023 20:12:40 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-with-dates-30-days-before/m-p/3176701#M114698 Anonymous 2023-04-06T20:12:40Z Re: Calculate with dates (30 days before) https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-with-dates-30-days-before/m-p/3176842#M114709 <P>hi @Anonymous</a>&nbsp;</P><P>try like:</P><DIV>Measure =</DIV><DIV>COUNTROWS(</DIV><DIV>&nbsp; &nbsp; FILTER(</DIV><DIV>&nbsp; &nbsp; &nbsp; &nbsp; TableName,</DIV><DIV>&nbsp; &nbsp; &nbsp; &nbsp; TableName[Date]&lt;TODAY()-30</DIV><DIV><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;)</SPAN></DIV><DIV><SPAN>)</SPAN></DIV> Thu, 06 Apr 2023 22:47:51 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-with-dates-30-days-before/m-p/3176842#M114709 FreemanZ 2023-04-06T22:47:51Z Re: Calculate with dates (30 days before) https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-with-dates-30-days-before/m-p/3203720#M116602 tks a lot ! Mon, 24 Apr 2023 20:35:30 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-with-dates-30-days-before/m-p/3203720#M116602 Anonymous 2023-04-24T20:35:30Z