Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
6 | |
4 | |
3 | |
3 |
User | Count |
---|---|
15 | |
9 | |
6 | |
3 | |
3 |