Error in queries

[Anonymous]

I am getting below error,

DataFormat.Error: We couldn't parse the input provided as a Date value.
Details:
Pending

[v-robertq-msft]

Hi, @Anonymous 

Have amitchandak’s reply helped you to solve this problem? Because to me, his reply has been very comprehensive.

If not, you can also try to change the data type of date field in sales information as "Locale" like this:

Here’s a case that has the same problem as yours:

https://community.powerbi.com/t5/Desktop/DataFormat-Error-We-couldn-t-parse-the-input-provided-as-a/td-p/84355

If you have solved this problem, would you like to mark your own reply as a solution so that others can learn from it too?

Thanks in advance!

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@Anonymous , to me it seems like your date format(system) is mm/dd/yyyy and you are getting the date in dd/mm/yyyy format or vice versa.

If you want to change the setting https://community.powerbi.com/t5/Desktop/How-to-apply-UK-date-format-dd-mm-yyyy-in-Date-slicer/td-p/599712

Or you want to change to the format

in dax

DD/MM/YYYY to MM/DD/YYYY
date(year( right(DD__MM__YY[date],4)), month(mid(DD__MM__YY[date],4,2)) ,day(left(DD__MM__YY[date],2)))
mid(DD__MM__YY[Version_Id],4,2) &"/"& left(DD__MM__YY[Version_Id],2) & "/" & right(DD__MM__YY[Version_Id],4)

MM/DD/YYYY to DD/MM/YYYY
date(year( right(DD__MM__YY[date],4)), month(left(DD__MM__YY[date],2)),day(mid(DD__MM__YY[Version_Id],4,2)) )

We have the same function as power query too start mid and end, Show in this video

https://www.youtube.com/watch?v=vky4wPqm0O0