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.
I have a DAX like
IF ( TABLE[ACNTNO.1] =71299 && TABLE[ACNTNO.2] =55 &&
TABLE[CODE] =AMCC,
TABLE[AMT]/2,
TABLE[AMT])
And it's giving an error saying that "DAX comparison operations do not support comparing values of type integer with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values."
What changes to do?
Solved! Go to Solution.
pls check the data type of TABLE[ACNTNO.1] and TABLE[ACNTNO.2] , to see if those columns' type are whole number or decimal number.
or try this
IF ( TABLE[ACNTNO.1] ="71299" && TABLE[ACNTNO.2] ="55" &&
TABLE[CODE] =AMCC,
TABLE[AMT]/2,
TABLE[AMT])
Proud to be a Super User!
pls check the data type of TABLE[ACNTNO.1] and TABLE[ACNTNO.2] , to see if those columns' type are whole number or decimal number.
or try this
IF ( TABLE[ACNTNO.1] ="71299" && TABLE[ACNTNO.2] ="55" &&
TABLE[CODE] =AMCC,
TABLE[AMT]/2,
TABLE[AMT])
Proud to be a Super User!
Thanks a ton! It was all about data type!
you are welcome
Proud to be a Super User!
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |