DAX IF Statement Error

[Bizo]

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")))))

[Greg_Deckler · Accepted solution]

@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"
  )

[Bizo]

Perfect, thanks!  You're a lifesaver!