Forum Discussion
Add a custom column
Hi All, I would like to add a custom column in query.I have shipping date in sales table - unfortunately original formt is text and day and month is otherway around. So I wrote the followin...
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.
