Forum Discussion
Helper IIIpower query unable to parse date / time
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?
Jebilaya , Your system is having US date format, the file is in UK date format.
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
1 Reply
- amitchandak
Super User
Jebilaya , Your system is having US date format, the file is in UK date format.
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