Forum Discussion
Extend Value to all Weeks going forward
Hi, My first post to community. I need help to extend value for all week endings from now. My Week ends on Saturday. First table is my current output from Power query where I have closing stock for e...
I prefer to keep things simple and although you have 960 items the solution demonstrated in the attached example should work for you. It askes for some preparation in Excel (create a table with all item numbers and a table with all the week-ending-dates).
See if you can apply the same steps to your actual data.