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."
look again carefully what and how I did, I don’t know what you have
the "Value" column is the sum column
Failed 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