cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## DAX IF Statement Error

Hi All,

Ihave this DAX statement below but I'm running into the below error:

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

I'm sure it's a simple solution but I just can't figure it out, any ideas?  Thank you in advance!

DueIn = IF([Days Due] < -44000, "No Due Date",
IF([Days Due] > -44000 < 0, "Overdue",
IF([Days Due] > 0 <= 30, "0 - 30 Days",
IF([Days Due] > 30 <= 60, "31 - 60 Days",
IF([Days Due] > 60 <= 90, "61 - 90 Days", "90+ Days")))))
1 ACCEPTED SOLUTION
Super User

@Bizo First, use a SWITCH(TRUE(),...) statement, much cleander and you have to write your true/false conditions like:

``````DueIn =
SWITCH(TRUE(),
[Days Due] < -44000, "No Due Date",
[Days Due] > -44000 && [Days Due] < 0, "Overdue",
[Days Due] > 0 && [Days Due] <= 30, "0 - 30 Days",
[Days Due] > 30 && [Days Due] <= 60, "31 - 60 Days",
[Days Due] > 60 && [Days Due] <= 90, "61 - 90 Days",
"90+ Days"
)``````

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
2 REPLIES 2
Super User

@Bizo First, use a SWITCH(TRUE(),...) statement, much cleander and you have to write your true/false conditions like:

``````DueIn =
SWITCH(TRUE(),
[Days Due] < -44000, "No Due Date",
[Days Due] > -44000 && [Days Due] < 0, "Overdue",
[Days Due] > 0 && [Days Due] <= 30, "0 - 30 Days",
[Days Due] > 30 && [Days Due] <= 60, "31 - 60 Days",
[Days Due] > 60 && [Days Due] <= 90, "61 - 90 Days",
"90+ Days"
)``````

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Frequent Visitor

Perfect, thanks!  You're a lifesaver!