Error in PowerBI DAX comparsion operations do not support comparing values of type text with values of type integer

Question

IF (Calender[income]<7000,"Silvercard", IF (Calender[income]<90000,"Goldcard","NoCard")) Can u give solution to this?? Can anyone tell me the error.

Shows above error in POWERBI i.e. DAX comparsion operations do not support comparing values of type text with values of type integer

Answer 1

The error is on the data type of your column Calender[income]. It is best practice to change the column data type to whole number or decimal.

Also, what you can do but is not ideal is using VALUE to transform the text into a number.

CalculatedColumn =
IF (
    VALUE ( Calender[income] ) < 7000,
    "Silvercard",
    IF ( VALUE ( Calender[income] ) < 90000, "Goldcard", "NoCard" )
)