Forum Discussion

Enan's avatar
Enan
Icon for Helper I rankHelper I
4 years ago

Date Error in table

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
Need Help
ReneMoawad's avatar
ReneMoawad
Icon for Resolver III rankResolver III
4 years ago

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)