Text to Date format change Value is incorrect

[Anonymous]

i have a issue if i change the text to Date and time means  date was wrong ,    basically my date field is  01/06/2020 00:10(DD/MM/YY)  if i change date and time means it will show 06/01/2020 00:10   that means 1st june 2020  changed to 6th Jan 2020

How to fix this issue

@vivran22   @nandukrishnavs 

[Pragati11 · Accepted solution]

Hi @Anonymous ,

You can achieve this format conversion in Query editor. Check the below article:

https://www.oraylis.de/blog/local-date-formats-in-power-bi

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati

[Anonymous]

Hi @Pragati11    i have tried but it's not working  error

[Pragati11]

Hi @Anonymous ,

Which local format did you select while doing this.

What locale format did you select? UK locale?

Also, whicle clicking on this error what message is displayed?

Thanks,

Pragati

[Anonymous]

Hi @Pragati11    Now it's Working fine

Thanks lot

[Tahreem24]

@Anonymous ,

See if below thread can you help you out!

https://community.powerbi.com/t5/Desktop/Change-Text-field-to-Date-format/m-p/692295

[Anonymous]

@Tahreem24  it's Not working  i'm getting error    "Cannot convert value '23/0' of type Text to type Integer."