topic DataFormat.Error: We couldn't parse the input provided as a date I know, but, how do I fix? in DAX Commands and Tips

DataFormat.Error: We couldn't parse the input provided as a date I know, but, how do I fix?

npate102 — Tue, 12 Nov 2019 14:55:28 GMT

Alright. I know this has probably been posted a gazillion time here; but, I'm getting an error

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

Details:

15-Oct-19*"

Now, as data is thousands of rows long, I can't check the data quality. If I sort it decending, it throws up an error obviously. I know that there's an error, and I want to solve it by removing that * at the end. but, how do I do it? It's not even letting me work on the error.

Re: DataFormat.Error: We couldn't parse the input provided as a date I know, but, how do I fix?

Anonymous — Tue, 12 Nov 2019 21:02:49 GMT

Hi npate102!

I'd suggest 3 things:

- On Edit Queries, replace value * for nothing

- Create a example column only with value you mentioned 15-Oct-19, and then deleting the previous column

- Check source and get root cause

Hope this helps 🙂

Barbara