power query unable to parse date / time

[Jebilaya]

I'm using power query to convert text values to date / time.  As you can see on screenshot below it does it correctly for the first few records but then returns the majority of the values left as errors even though there is no discernible difference in format.

Any ideas?

[amitchandak · Accepted solution]

@Jebilaya , Your system is having US date format, the file is in UK date format.

https://community.powerbi.com/t5/Desktop/How-to-apply-UK-date-format-dd-mm-yyyy-in-Date-slicer/td-p/...

or convert

date(( right(DD__MM__YY[date],4)), (mid(DD__MM__YY[date],4,2)) ,(left(DD__MM__YY[date],2)))

DAX Functions- LEFT, MID, RIGHT: https://youtu.be/HEa72qLvxXo

Power Query - Text.Start, Text.Middle, Text.End: https://www.youtube.com/watch?v=vky4wPqm0O0