https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Running-Total-issue/m-p/1634608#M33162 <P>yes, somewhere in your measure you need to specify the 36 month range filter.&nbsp;Please provide sample data in usable format (not as a picture) and show the expected outcome.</P> Mon, 01 Feb 2021 03:06:42 GMT lbendlin 2021-02-01T03:06:42Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Running-Total-issue/m-p/1633080#M33109 <P>Hi All,</P><P>I am trying to get 36 months running total .</P><P>My Measure :</P><DIV><DIV><SPAN>Unnassisted Pole Failures (3 Yrs) = </SPAN></DIV><BR /><DIV><SPAN>Var Result = </SPAN></DIV><DIV><SPAN>CALCULATE(</SPAN></DIV><DIV><SPAN>[Monthly Pole Failures],</SPAN></DIV><DIV><SPAN>FILTER(</SPAN></DIV><DIV><SPAN>CALCULATETABLE(</SPAN></DIV><DIV><SPAN>SUMMARIZE('Incidents', 'Incidents'[Start_Of_Month], 'Incidents'[Month]),</SPAN></DIV><DIV><SPAN>ALLSELECTED('Incidents')</SPAN></DIV><DIV><SPAN>),</SPAN></DIV><DIV><SPAN>ISONORAFTER(</SPAN></DIV><DIV><SPAN>'Incidents'[Start_Of_Month],max(Incidents[Start_Of_Month]), DESC )&amp;&amp; 'Incidents'[Start_Of_Month]&lt;= max(Incidents[Start_Of_Month]))</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV><SPAN>return result </SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>This measure is giving running total for all years but I am looking for every 36&nbsp; months.</SPAN></DIV><DIV>&nbsp;</DIV><DIV>&nbsp;</DIV></DIV> Sat, 30 Jan 2021 09:15:42 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Running-Total-issue/m-p/1633080#M33109 Priya2007 2021-01-30T09:15:42Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Running-Total-issue/m-p/1634608#M33162 <P>yes, somewhere in your measure you need to specify the 36 month range filter.&nbsp;Please provide sample data in usable format (not as a picture) and show the expected outcome.</P> Mon, 01 Feb 2021 03:06:42 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Running-Total-issue/m-p/1634608#M33162 lbendlin 2021-02-01T03:06:42Z