Forum Discussion
Wrong date import from excel file
Hi, The date import from excel is incorrect. For example, the dates highlighted in yellow has reverse date and month. Those date from 1 to 12 will become the month instead of the date. Eg: ...
Anonymous - you had similar issue previously and I think this was resolved here- https://community.powerbi.com/t5/Desktop/Inconsistent-Date-Format-in-excel-file/m-p/1447247#M607073
PhilipTreacy
Super User
Super UserHi Anonymous
The source file you provided has dates in dd/mm/yyyy format. I don't know what you are doing once you get the dates into PBI but if you just select the columns and then right click the column header then Change type -> Using Locale
then choose Date and English (United States)
They should convert properly to your locale.
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.