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
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=Dj5M3MIn 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
look again carefully what and how I did, I don’t know what you have
the "Value" column is the sum columnFailed to save modifications to the server. Error returned: 'Cannot convert value 'May'23' of type Text to type Date.
The current operation was cancelled because another operation in the transaction failed.
'.give the file to see what is causing this error