Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |