Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |