Forum Discussion
Change Date when source date is 'Text' and Euro Format
- 6 years ago
Anonymous
Refer to this post.
https://community.powerbi.com/t5/Desktop/Date-Change-from-DD-MM-YYYY/m-p/908449#M435414
Looks at the screenshots.
In Query Editor,Right Click in the column - Change Type-Using Locale - Select the Type (Date Time) and Select the Locale.In the pop up window, choose date datatype and English(United Kingdom) as Locale.
If this helps, mark it as a solution
Kudos are nice too
Anonymous
Refer to this post.
https://community.powerbi.com/t5/Desktop/Date-Change-from-DD-MM-YYYY/m-p/908449#M435414
Looks at the screenshots.
In Query Editor,Right Click in the column - Change Type-Using Locale - Select the Type (Date Time) and Select the Locale.In the pop up window, choose date datatype and English(United Kingdom) as Locale.
If this helps, mark it as a solution
Kudos are nice too