topic dax explanation for 7D AVG in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/dax-explanation-for-7D-AVG/m-p/4050512#M160707 <P>Hi all,</P><P>&nbsp;</P><P>Can you explain me the logic below?</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><DIV><DIV><SPAN>ROLLING_7D_AVG_CON =</SPAN> <SPAN>VAR</SPAN> <SPAN>NumOfDays</SPAN><SPAN> = </SPAN><SPAN>7</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>LastCurrentDate</SPAN><SPAN> =</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>MAX</SPAN><SPAN> (</SPAN><SPAN>Channel_Data</SPAN><SPAN>[DATE]</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>Period</SPAN><SPAN> =</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>DATESINPERIOD</SPAN><SPAN> (</SPAN><SPAN>Channel_Data</SPAN><SPAN>[DATE]</SPAN><SPAN>, </SPAN><SPAN>LastCurrentDate</SPAN><SPAN>, - </SPAN><SPAN>NumOfDays</SPAN><SPAN>, </SPAN><SPAN>DAY</SPAN><SPAN> )</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>Result</SPAN><SPAN> =</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>CALCULATE</SPAN><SPAN> (</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>AVERAGEX</SPAN><SPAN> (</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>VALUES</SPAN><SPAN> (</SPAN><SPAN>Channel_Data</SPAN><SPAN>[DATE]</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>[TOTAL_CONVERSIONS]</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; ),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>Period</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>RETURN</SPAN></DIV><DIV><SPAN>Result</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Thank you.</SPAN></DIV></DIV> Fri, 19 Jul 2024 10:08:53 GMT ROG 2024-07-19T10:08:53Z dax explanation for 7D AVG https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/dax-explanation-for-7D-AVG/m-p/4050512#M160707 <P>Hi all,</P><P>&nbsp;</P><P>Can you explain me the logic below?</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><DIV><DIV><SPAN>ROLLING_7D_AVG_CON =</SPAN> <SPAN>VAR</SPAN> <SPAN>NumOfDays</SPAN><SPAN> = </SPAN><SPAN>7</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>LastCurrentDate</SPAN><SPAN> =</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>MAX</SPAN><SPAN> (</SPAN><SPAN>Channel_Data</SPAN><SPAN>[DATE]</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>Period</SPAN><SPAN> =</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>DATESINPERIOD</SPAN><SPAN> (</SPAN><SPAN>Channel_Data</SPAN><SPAN>[DATE]</SPAN><SPAN>, </SPAN><SPAN>LastCurrentDate</SPAN><SPAN>, - </SPAN><SPAN>NumOfDays</SPAN><SPAN>, </SPAN><SPAN>DAY</SPAN><SPAN> )</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>Result</SPAN><SPAN> =</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>CALCULATE</SPAN><SPAN> (</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>AVERAGEX</SPAN><SPAN> (</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>VALUES</SPAN><SPAN> (</SPAN><SPAN>Channel_Data</SPAN><SPAN>[DATE]</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>[TOTAL_CONVERSIONS]</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; ),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>Period</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>RETURN</SPAN></DIV><DIV><SPAN>Result</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Thank you.</SPAN></DIV></DIV> Fri, 19 Jul 2024 10:08:53 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/dax-explanation-for-7D-AVG/m-p/4050512#M160707 ROG 2024-07-19T10:08:53Z Re: dax explanation for 7D AVG https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/dax-explanation-for-7D-AVG/m-p/4050537#M160710 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="398723" data-lia-user-login="ROG" class="lia-mention lia-mention-user">ROG</a>&nbsp;</P><P>This measure computes the rolling average of the [TOTAL_CONVERSIONS] over the past 7 days relative to the latest date in your dataset.</P><P>&nbsp;</P><P>BBF</P> Fri, 19 Jul 2024 10:23:46 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/dax-explanation-for-7D-AVG/m-p/4050537#M160710 BeaBF 2024-07-19T10:23:46Z