Forum Discussion
Moving average 3 weeks
I am new to Power Query and I'm trying to create a query template that applies a 3 moving average to the volume and sales for the next 3 weeks grouped by weekday for each product. My input table loo...
v-jingzhang
Community Support
Community SupportHi donpep0
What do you currently have for the next 2nd and 3rd week? If you have null values in them, you can possibly use Fill Down feature. After that, transform the column to show null for index 1 and 2.
I'm not sure how to tell which week is expected to be the current week thus which values should be expected for next weeks. Can you explain the logic why you highlight those values? Is it because the latest week in the table is the week that 07/29/2022 lies in? If so, do we need to add new rows for those "next dates"?
Best Regards,
Community Support Team _ Jing