Forum Discussion
DataFormat.Error: We couldn't parse the input provided as a Date value.
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.
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.
5 Replies
Can you replace this value with blank? Or have a new column like
if (a="--/--/----", blank(),a)
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: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.
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.
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.
