Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
Solved! Go to 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 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!
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
12 | |
10 | |
10 | |
6 |