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!

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors