Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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: ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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's avatar
amitchandak
Super User
6 years ago

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

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      amitchandak
      Super User
      6 years ago

      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.