Plot moving average on every day of year

[Anonymous]

I have a table with several columns. One column is the date. Another column is the plant. Another column is the daily production. I want to plot the 10-day moving average of the daily production for a specific plant that the user can select, factoring in zero daily production for days when the plant did not produce. If the plant did not produce on a particular day, there is no record of production (data will not appear with zeros in my data set). I want the horizontal axis of my chart to show me all the days of the year. What is a good way to achieve this goal?

My attempt was to create a measure

Measure = CALCULATE(SUM(production,DATESINPERIOD(dates,LASTDATE(dates)),-10,DAY))/10

That seems to work on the days when the plant produced something, but it only returns values on the days when the plant produced , whereas I want the measure to be calculated on every single day, factoring in zeros for days when there are no records of production for the plant. I have tried changing continuous/categorical x-axis but that does not fix it.

[Greg_Deckler · Accepted solution]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

FYI, I don't understand the logic of creating the same post 3 times with different titles...

[Anonymous]

Apologies, it was totally unintended. I had trouble receiving the email verification email (due to email filters of my employer) when I first signed up and I uploaded the post three times by mistake (with different titles unintendedly)