I have an excel file of sales data, with a column for purchase date.
When i import into power bi, it displays the dates very strangly (20-sep-25, 30-may-37 etc).
Any ideas why this is happening?
Go to Solution.
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
I just noticed too that they're all fine in the Query editor, but not in the main data section
You could try to change the format of this column
If it is not your case, please share your excel file just with one purchase Date column. You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.
Power BI Super User, Greg Deckler, explains
Register by September 5 to save $200
Engage and empower students with Power BI!
Continue your learning in our online communities.