Forum Discussion
Incorrect local date - Australian format
Hi, (Power BI version - Sept 2018 desktop) I am importing data from SAP BW. I have a date field in the source which imports as text. it comes as dd.mm.yyyy eg for 28th August 2018 it is 28.08.2...
Hi Anonymous,
There is a easiest way to change text column to date, you can set the Regional Setting in Power BI desktop as English (Australia), save the change and reopen the report. Go to Query Editor, select the date column, change it to Date type.
By the way, there is a October Power BI desktop released, you can update your desktop to this version 2.63.3272.40262.
Best Regards,
Qiuyun YuHi Anonymous,
You can insert a step to replace value # as blank before you change data type to date. Please select the date column, then click Replace Values, type below:
Best Regards,
Qiuyun Yu
Hi Anonymous,
As the issue is resolved now, I will close this thread.
Best Regards,
Qiuyun Yu