Reply
Highlighted
Frequent Visitor
Posts: 7
Registered: ‎04-06-2017

Re: Lab 1 Exercise 2 - Changing Data Type to Date

You should have changed the column from text to date before filtering the date.

 

Cheers,

Frequent Visitor
Posts: 4
Registered: ‎04-20-2017

Re: Lab 1 Exercise 2 - Changing Data Type to Date

Hello,

We also encountered this error, but had a different solutoin.

For us, the fix was to change our Regional Settings to "English (United States)", rather than English(Australian). (Do this from the main menu > Options and settings > Options > Regional Settings)

The reason we were getting so many date errors was because PowerBI was trying to convert the dates into the Australian format of DD/MM/YYYY, rather than the US format of MM/DD/YYYY.

Once we changed our Regional Setting, the errors disappeared and all dates were converted correctly to Date type.

Kind regards,

Alice