Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Switch statement comparision datat type error

Hi,

 

I have the following code

 

 

 

Missed Deadlines =
SWITCH (
    TRUE (),
    'Maintenance Ticket System'[Status] = "Critical"
        && 'Maintenance Ticket System'[JobStarted]>1,"Missed",
    'Maintenance Ticket System'[Status] = "High"
       && 'Maintenance Ticket System'[JobStarted]>2,"Missed",
    'Maintenance Ticket System'[Status] = "Medium"
    && 'Maintenance Ticket System'[JobStarted]>3,"Missed",
    'Maintenance Ticket System'[Status] = "Low"
    && 'Maintenance Ticket System'[JobStarted]>5,"Missed"
)

 

 

 

Job Started is a Whole Number and Status is text.

Job Started is a calculated column.

 

The error message I am getting is.....

 

DAX comparison operations do not support comparing values of type Text with values of type Integer. Consider using the VALUE or FORMAT function to convert one of the values.

 

Any help appreciated.

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    The solution was because Job Started had a formula using datediff it seeemd to return text, even though the Job Started column was a whole number .. that didnt throw up an error.. however adding VALUE in front of the date diff on the job started column seemed to resolve the issue.

2 Replies

  • johnt75's avatar
    johnt75
    Super User
    4 years ago

    Check the types of the columns in Power Query, the issue could be there.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    The solution was because Job Started had a formula using datediff it seeemd to return text, even though the Job Started column was a whole number .. that didnt throw up an error.. however adding VALUE in front of the date diff on the job started column seemed to resolve the issue.