Forum Discussion
Change Date when source date is 'Text' and Euro Format
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
Check if it can be detected as the British date format. else the way out have a new column
New date = mid(DD__MM__YY[Date],4,2) &"/"& left(DD__MM__YY[Date],2) & "/" & right(DD__MM__YY[Date],4)
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedin