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
Great. You did fantastic work. But I have got an error.
"Column 'Value' in the table cannot be found or may not be used in this expression. Column 'Value' in the table cannot be found or may not be used in this expression. Column 'Value' in the table cannot be found or may not be used in this expression."
in this version I made a small change, removed the weekend days
https://1drv.ms/u/s!AiUZ0Ws7G26RhxQzx1qDV_e2UulW?e=Dj5M3M
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.