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

[Anonymous]

Hi everyone,

Im having a error it terms of my "RegDate" when i try to add into group by and the error says:

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

In my regdate raw data I have that "--/--/----" when i try toremove  that errors it minus my total sum of the result
what i try to do:
1. i will remove errors to my raw data

2. when i remove errors then i can put my regdate column in my group by, then i will add that regdate to my current group by

BUT the value get affected before it is 186,329.27 now is 186278.27 😞

is there anyway i can handle this error? because i want to add that regdate to my current group by. 

[Anonymous]

Hi @Anonymous 

Has the question been solved, did my answer help you?

Could you please accept my post as the solution if it helps?

Please feel free to ask if you have any questions.

Best Regards,

Jay

Community Support Team _ Jay Wang

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

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please try right-clicking “--/--/----” in Query Editor -> Replace Values, replace with null. Then you should be able to change regdate to Date type.

Best Regards,

Jay

Community Support Team _ Jay Wang

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

[amitchandak]

Can you replace this value with blank? Or have a new column like

if (a="--/--/----", blank(),a)

[Anonymous]

@amitchandak 

Hi i try to do your formula but it seems to have an error? Also if the formula has been rectified i can just use that "Regdate" to add into my group by without getting the error again?

here's the error:

[amitchandak]

I was able to create one sample data -

Column = if(Sheet1[Date]="--/--/----",BLANK(),Sheet1[Date])

.

If possible please share a sample pbix file after removing sensitive information.