SWITCH DAX error

[Anonymous]

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!

[Tahreem24]

@Anonymous What exact error is it showing?

[Anonymous]

this is the error, unexpected expression for those in red line

[Jos_Woolley]

Hi,

I don't see anything wrong with that construction. For which values is it not working? Please give some examples.

Regards

[Anonymous]

[Jos_Woolley]

You haven't tried to enter that as a measure, as opposed to a calculated column, by any chance?

Regards

[ryan_mayu · Accepted solution]

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