Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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

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

     

  • Hi,

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

    Regards

    • Anonymous's avatar
      Anonymous
      Not applicable

       

      • Jos_Woolley's avatar
        Jos_Woolley
        Solution Sage

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

        Regards

    • Anonymous's avatar
      Anonymous
      Not applicable

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