Forum Discussion
Convert data from monthly format into weekly
1) in power query divided sales into daily sales and created a date in the same place
2) I created a calendar, if you don't like this calendar you can create your own
In the Second Calender. also some totals are wrong.
It differs by 1.
I'm attaching an image for your reference.
Thanks.
only need to round to two decimal places
Done.Thank you so much for your help.
https://www.dropbox.com/scl/fi/g2vcupkp6ghzykfubcj1p/Merged-Forecast.xlsx?dl=0&rlkey=p35g27v9nxmcsqqptzholq0dn
Please check this data.
There are 3 sheets.
In first, Data is in weekly basis.
In second and third, Data is in monthly basis.
Now I want to append all these sheets and final result should displayed in weekly basis for all of these.
Please help.
And also tell me if this conversion and Append possible in Excel.