Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
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?
Thank you!
Sonia
Solved! Go to Solution.
hi, @Anonymous
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Best Regards,
Lin
hi, @Anonymous
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.
Best Regards,
Lin
I just noticed too that they're all fine in the Query editor, but not in the main data section
Thanks again!
hi, @Anonymous
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Best Regards,
Lin
User | Count |
---|---|
94 | |
79 | |
74 | |
64 | |
60 |
User | Count |
---|---|
106 | |
97 | |
76 | |
63 | |
61 |