Forum Discussion
carlbh
7 years agoHelper I
Errors when changing data type to Date
I wonder if anyone can help. I have just noticed after importing a whole load of data from excel, that PBI is converting my date information to US format when the month is greater than the day. The ...
carlbh
7 years agoHelper I
I am hoping there is a more central solution to this issue, I dont want to have to keep addding a new column like this every time I create a new report.
This is pretty fundamental, surely there is a microsoft solution out there......
v-chuncz-msft
7 years agoCommunity Support
You may take a look at https://answers.microsoft.com/en-us/windows/forum/all/win-10-date-format-problem-i-need-ddmmyy-date/c5e473f8-5300-4634-bf7b-084245e05eef.