Date Error in table

[Enan]

Hi Guys,

I am having an error (Pic 1), Need your guidance and help plzz.

I have load the data in the new pbix file but in new file error is not coming. (Pic 2)

Thank you

[ReneMoawad]

The Date format in the first image is set to MM-DD-YYYY and your data is DD-MM-YYYY

• Remove the step that is changing the Date format of the date column
• Right click on the Column name, Change Type, Using locale

• select Data Type "Date" and change the Locale to  English (United Kingdom)

[amitchandak]

@Enan , Your system is using US format and in Power BI you are getting dates in UK Format.

You need to create a new column in Power Query

#date(Number.FromText(Text.End([Date],2) ) ,Number.FromText(Text.Middle([Date],3,2) ) ,Number.FromText(Text.Start([Date],2) ) )

Discussed same here

Power Query - Text.Start, Text.Middle, Text.End: https://www.youtube.com/watch?v=vky4wPqm0O0