https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average/m-p/3568059#M137557 <P>&nbsp;Dear.</P><P>&nbsp;</P><P>need your help to solve the average of request received per month :</P><P>&nbsp;</P><P>Date Received&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Request Number</P><P>10/01/23&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AS-202222</P><P>10/02/23&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AS-202223</P><P>10/03/23&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AS-202224</P><P>10/04/23&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AS-202225</P><P>10/05/23&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AS-202226</P><P>10/06/23&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AS-202227&nbsp;</P> Tue, 05 Dec 2023 09:27:10 GMT beverajr 2023-12-05T09:27:10Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average/m-p/3151142#M112865 <DIV class=""><DIV class=""><DIV class=""><DIV class=""><SPAN>good afternoon, the idea is to calculate the average of the quarterly values, can someone help me?</SPAN></DIV><DIV class="">&nbsp;</DIV><DIV class=""><img /><P>&nbsp;</P><BR /><P>&nbsp;</P></DIV></DIV></DIV></DIV> Thu, 23 Mar 2023 22:39:32 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average/m-p/3151142#M112865 jhodasoft 2023-03-23T22:39:32Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average/m-p/3151392#M112872 <P>=AVERAGEX(VALUES[Quarters],[Measure])</P> Fri, 24 Mar 2023 02:26:18 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average/m-p/3151392#M112872 wdx223_Daniel 2023-03-24T02:26:18Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average/m-p/3152769#M112990 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="264353" data-lia-user-login="wdx223_Daniel" class="lia-mention lia-mention-user">wdx223_Daniel</a>&nbsp;thank you so much!, I solve it:</P><DIV><DIV><SPAN>Average = </SPAN><SPAN>AVERAGEX</SPAN><SPAN>(</SPAN><SPAN>values</SPAN><SPAN>(</SPAN><SPAN>DIM_Rotacion</SPAN><SPAN>[trimestre]</SPAN><SPAN>),</SPAN><SPAN>[m_evolucion_rotacion]</SPAN><SPAN>)</SPAN></DIV></DIV> Fri, 24 Mar 2023 14:36:46 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average/m-p/3152769#M112990 jhodasoft 2023-03-24T14:36:46Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average/m-p/3568059#M137557 <P>&nbsp;Dear.</P><P>&nbsp;</P><P>need your help to solve the average of request received per month :</P><P>&nbsp;</P><P>Date Received&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Request Number</P><P>10/01/23&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AS-202222</P><P>10/02/23&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AS-202223</P><P>10/03/23&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AS-202224</P><P>10/04/23&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AS-202225</P><P>10/05/23&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AS-202226</P><P>10/06/23&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AS-202227&nbsp;</P> Tue, 05 Dec 2023 09:27:10 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average/m-p/3568059#M137557 beverajr 2023-12-05T09:27:10Z