31 Years of Python | 48 Hour Sale Extension!!!
days
hours
minutes
seconds

Formatting the date as per instructions doesnt work in Guided Project

https://app.dataquest.io/c/122/m/692/guided-project%3A-modeling-data-in-power-bi/3/clean-the-dataset

I just tried to change the text to date type after matching the format but then the date is of type mm-dd-yyyy and not dd-mm-yyyy as per notes. Is it the true that powerbi cant convert the mm-dd-yyyy without running into errors? I saw some workaround in google but its long winded

Hi. Did you figure it out?
Changing the format to “Date” causes errors in the cells.
Replacing the “/” with “-” doesn’t mend the problem, as you can’t change the format of the column to “Date”. When I do so, I get this:
“DataFormat.Error: We couldn’t parse the input provided as a Date value.
Details:
11-14-2013”

What worked for me was to right click the date column → change type → using locale

Then adjust the locale and data type here.

1 Like

I’m interested to hear how this differs among users, because for me it automatically applied the change when I imported it into PBI from my desktop. It is a step that I can delete, but it definitely isn’t one that I made myself.

I’m using the desktop version that I downloaded from the Microsoft store, I wonder if that changes anything?