cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jak828
Helper I
Helper I

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.

1 ACCEPTED SOLUTION
jak828
Helper I
Helper I

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.

View solution in original post

2 REPLIES 2
jak828
Helper I
Helper I

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.

johnt75
Super User
Super User

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

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.