Forum Discussion
Solved
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")))))
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" )
2 Replies
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" )Perfect, thanks! You're a lifesaver!
