Forum Discussion
Solved
Lab 1 - step 4 filter dates
Hello, I'm having a problem with step 4 of Lab 1. When I attempt to change the type of the 'Date' column from ABC to Date, the majority of rows come up as 'Error'. See screenshot below. ...
Hello,
Thanks, we have worked out the problem.
I had forgotten to change my Regional Settings to "English (United States)" - it was set on English (Australia), so when PowerBI tried to convert the dates to the Australian way of writing dates, as DD/MM/YYYY, most of the months were out of range! Hence the errors.
Kind regards,Alice
My apologies, I think I may have accidentally posted this in the wrong forum.
It is in relation to a PowerBI course I'm doing on edX:
https://www.edx.org/course/analyzing-visualizing-data-power-bi-microsoft-dat207x-5
Regards,
Alice
No worries. Good luck with your course! At least you solved one issue, so that must be promising. :smileyhappy: