Forum Discussion
Convert data from monthly format into weekly
I have my data in a monthly format. But I want to convert it into a weekly format. My column data type is text currently. And I'm unable to convert it into date data type. Expected Ou...
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
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