Date parameter value error with data type

jgmendez — Mon, 27 Sep 2021 16:09:16 GMT

Hello, I am trying to add a date parameter but am receiving the following error

"Query (1, 148) DAX comparison operations do not support comparing values of type Date with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values.
----------------------------
Query execution failed for dataset 'ToHiresTerminationsEmploymentDetailsCurrentHireDate'."

I have tried Format, Parse and DateValue as suggested in other threads but adding anything to the Query code breaks it

Any ideas on how to fix this?

Thanks,

Joe

Re: Date parameter value error with data type

Anonymous — Thu, 30 Sep 2021 02:13:03 GMT

jgmendez

Which datasource are you connecting to? Instead add datevalue() in the query formula. You might want to go the datasource then change the data type of the columns to a same comparable type (date type).

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

topic Re: Date parameter value error with data type in Report Server

Date parameter value error with data type

Re: Date parameter value error with data type