Change Date when source date is 'Text' and Euro Format

[Anonymous]

Hello all, 

I have an issue where I am trying to, within Power BI, adjust the Date column from my source data to be an actual date in MM/DD/YYYY format. 

The way it comes in from my source data (.csv) is in Text format, formatted like DD.MM.YYYY 00:00:00 (screenshot below from the Excel File). I cannot alter the source data, any adjustments must be made in Power BI. 

I have tried changing locale, making from text->date, ect. It never recognizes it. What's my best course of action here?

[amitchandak]

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

[VasTg · Accepted solution]

@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