Unable to use numeric as well as text condition in IF statement dax

[Dshami]

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?

[ryan_mayu · Accepted 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])

[Dshami]

Thanks a ton! It was all about data type!

[ryan_mayu]

you are welcome