dax comparison operations do not support comparing values of type true/false with values of type int

[Anonymous]

Hi Folks, 

I trying to create a calculated column using IF condition on a numerical column. But I am getting an error as 

DAX comparison operations do not support comparing values of type true/false with values of type int

I have used the below formula on my calculated column: The column [Payment term Days] is of a number data type with values in the range 0 -180

if (Vendors[Payment term Days] = 0,"On Receipt",

IF(0<Vendors[Payment term Days]<=14, "0-14",

IF(14<Vendors[Payment term Days]<=30,"15=30",

IF(30<Vendors[Payment term Days]<=60,"45-60",

"75-180"))))

Any input will be really helpful.

Thanks

Sankalp

[v-yangliu-msft · Accepted solution]

Hi  @Anonymous  ,

You need to use the double ampersand "&&" between logical parameters

Reproduce your results:

The modified function is:

Column =
IF(Vendors[Payment term Days] = 0,"On Receipt",
IF(0<Vendors[Payment term Days]&&Vendors[Payment term Days]<=14, "0-14",
IF(14<Vendors[Payment term Days]&&Vendors[Payment term Days]<=30,"15=30",
IF(30<Vendors[Payment term Days]&&Vendors[Payment term Days]<=60,"45-60",
"75-180"))))

Result：

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ERD]

Hi @Anonymous ,

It should be written in a different way (using "&&"), like 

IF (
    Vendors[Payment term Days] <= 400 && Vendors[Payment term Days] > 0,
    "0-400"
)

Anyway, I would use SWITCH in your case:

SWITCH (
    TRUE (),
    Vendors[Payment term Days] = 0, "On Receipt",
    Vendors[Payment term Days] > 0
        && Vendors[Payment term Days] <= 14, "0-14",
    Vendors[Payment term Days] > 14
        && Vendors[Payment term Days] <= 30, "15=30",
    Vendors[Payment term Days] > 30
        && Vendors[Payment term Days] <= 60, "45-60",
    "75-180"
)

If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.