Forum Discussion
SWITCH DAX error
The formula below is not working for some reason.. Can somebody help correct me?
SWITCH (
TRUE,
[Days] < 30, "<30 Days",
[Days] >= 30 && [Days] <= 69, "30-69 Days",
[Days] >= 70 && [Days] <= 100, "70-100 Days",
[Days] >= 101 && [Days] <= 140, "101-140 Days",
[Days] >= 141 && [Days] <= 180, "141-180 Days",">180 Days")
The logic is this:
IF [Days] <30 THEN "<30 Days"
ELSEIF [Days] >= 30 AND [Days] <= 69 THEN "30-69 Days"
ELSEIF [Days] >= 70 AND [Days] <= 100 THEN "70-100 Days"
ELSEIF [Days] >= 101 AND [Days] <= 140 THEN "101-140 Days"
ELSEIF [Days] >= 141 AND [Days] <= 180 THEN "141-180 Days"
ELSE ">180 Days" END
Thank you!
Anonymous
maybe try this
SWITCH (
TRUE(),
[Days] < 30, "<30 Days",
[Days] <= 69, "30-69 Days",
[Days] <= 100, "70-100 Days",
[Days] <= 140, "101-140 Days",
[Days] <= 180, "141-180 Days",">180 Days")
6 Replies
- ryan_mayuSuper User
Anonymous
maybe try this
SWITCH (
TRUE(),
[Days] < 30, "<30 Days",
[Days] <= 69, "30-69 Days",
[Days] <= 100, "70-100 Days",
[Days] <= 140, "101-140 Days",
[Days] <= 180, "141-180 Days",">180 Days") - Jos_WoolleySolution Sage
Hi,
I don't see anything wrong with that construction. For which values is it not working? Please give some examples.
Regards
- AnonymousNot applicable
- Jos_WoolleySolution Sage
You haven't tried to enter that as a measure, as opposed to a calculated column, by any chance?
Regards
- Tahreem24Super User
Anonymous What exact error is it showing?
- AnonymousNot applicable
this is the error, unexpected expression for those in red line