Forum Discussion
Add a custom column
"day and month is otherway around" Can you show us a date exactly please?
Hi HotChilli,
Thank you for your message. It looks like this. The original data is stored as text and when I try to convert to date by Data Type, I get 6 Jan 2019 while it is supposed to be 1 Jun 2019. I want to add new column and amend it in query.
All the best,
LoveParis
Hi paris ,
To try to match your issue, I created a table in Excel with date as a text field.
Then used PQ to bring it into PBI and it was brought in as a date field and formatted correctly.
So, I changed it back to a text field in the query.
And then changed it back to a date field. It formatted correctly.
It seems to be working as expected...can you provide us more detail?
Thanks,
Hi paris ,
You might also check your regional settings:
Choose the locale for importing data into Power BI Desktop- In Power BI Desktop, go to File > Options and settings > Options.
- Under Current file, select Regional Settings.
- In the Locale for import box, select a different locale.
If this solves your issue, please consider marking this as the solution.
