Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello!
I created a calculated table, but the following error occurred in the formula:
FORMULA = FILTER (PBICAIXACNPJ; PBICAIXACNPJ[CODE] = "3")
DAX comparison operations do not support the comparison of Integer-type values with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values. I changed the data type, but it did not work.
Please help me.
Solved! Go to Solution.
Try not using quote marks for the 3, just leave it as is.
Quote marks should only be for text values, otherwise it'll auto chang ethe datatype to text.
Try not using quote marks for the 3, just leave it as is.
Quote marks should only be for text values, otherwise it'll auto chang ethe datatype to text.
User | Count |
---|---|
106 | |
90 | |
82 | |
76 | |
73 |
User | Count |
---|---|
112 | |
103 | |
96 | |
74 | |
67 |