Forum Discussion
7-day Rolling Average help
Hello, I am struggling with replicating a 7-day rolling average in Power BI that I can easily do in Excel. I'm new to Power BI and am struggling with search terms so this is probably a simple questio...
Ashish_Mathur
Super User
Super UserHi,
In counting 6 days prior, you have ignored days on which there is no scrap count. Shouldn't those days be incouded with a value of 0 i.e. as on Feb 13, 2022, shouldn't 6 prior days be Feb 7 - 12?