Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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...
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...
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)
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |