Forum Discussion
Power query insert rows in between based on number of days between moths.
Hi! I am not sure if power query is the best way to do this… But I want to insert/copy X new rows in between already existing rows based on the number of days between the dates. Please see pic f...
Thanks for your answers!
I have attached a file were I try to explain what I want to accomplish.
Victor107200 Added a DailySales sheet to your file with a pivot table to check the totals.
By the way, I needed to copy the numbers in the forecast table and paste them back as values. The EDATE function looking at "maj" and "okt" caused value errors on my system.
- Thanks a lot Riny! I would never have figured this out my self and I have been looking throughe so many youtube videos... I think this might work for me. I will try and redo the steps you have done and see if I get the same results on the actual data.
Victor107200 Use this one instead. With a slight modification it is now more dynamic. Allowing for new products and markets.
