Backward 7 days moving average including zero

Question

Hello,&nbsp;I am still struggling with BACKWARD moving average including ZERO value.&nbsp;My original data was blank when no data. Thanks to Forum's help, now&nbsp;I added new line contains both zero value and other value called SALES[SALES_TOTAL]&nbsp;Could you please help what is wrong with this measure?&nbsp;Rolling average =VAR select_date =&nbsp;&nbsp;&nbsp; MAX (CALENDAR[Date])VAR end_Date = select_date - 7VAR Branch_select =&nbsp;&nbsp;&nbsp; MAX (BRANCH[BRANCH])RETURN&nbsp;&nbsp;&nbsp; CALCULATE (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AVERAGEX (SALES, SALES[SALES_TOTAL]),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FILTER (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL (SALES),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SALES[SALES_DATE] &lt;= select_date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &amp;&amp; SALES[SALES_DATE] &gt;= end_Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &amp;&amp; SALES[BRANCH] = Branch_select&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )&nbsp;&nbsp;&nbsp; )&nbsp;All the best,coco

v-piga-msft · Accepted Answer

Hi cocomy，&nbsp;From the function you provide, I cannot reproduce the scenario as yours. The syntax of the measure has no problem, but for the zero value, it may not return the value you expect.&nbsp;Could you share a dummy pbix file which can reproduce the scenario, so that we can help you better?&nbsp;You could upload it to OneDrive or Dropbox and post&nbsp;the link here. Do mask sensitive data before uploading.)&nbsp;Best Regards,Cherry &nbsp;

Forum Discussion

Backward 7 days moving average including zero

1 Reply

Related content

Backwards Deployments

Backwards Deployment

Getting data from Azure Event Grid backwards

Creating Hierarchy "Backwards"

Average and Moving Average