Forum Discussion
Solved
Date format - having excel file date format i.e. 27 January 2020 - need to be 27-01-2020
Importing a excel file to data model in excel. All dates are like this: 31 January 2020 30 January 2020 2 February 2020 4 February 2020 I need in the format dd/mm/yyyy, like 31-01-2020 I am...
Hi LarsHansson
Jimmy801's solution should be helpful.
If not, please take advice below:
If you use "English(United States) under System setting->Time &Language->Region,
then use default setting for Power BI->Files->Options and settings->Region,
The date is of mm/dd/yyyy by default, it is hard to get date formated as dd/mm/yyyy.
One workaround is to create a calculated column which is of text format.
Column = FORMAT([Date],"dd-mm-yyyy")As tested, when change the setting to other language, for example, demark, which format for date is dd/mm/yyyy, then you could change the date format as expected.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
