Forum Discussion

Nick555's avatar
Nick555
Icon for Helper I rankHelper I
3 years ago
Solved

Switch Statement Not Evaluating Properly

Greetings!

 

I am trying to use a Switch statement to populated a column with values. IT only evaluates the first part and not the second. This leaves me with a column of 1's and blanks instead of 1's, 2's and blanks. Any ideas what I am doing worng?

Thanks

TEST =
    SWITCH(
        TRUE(),
        'Sheet1'[COVRG_CD] <> "X1" && 'Sheet1'[COVRG_CD] <> "Y1" && 'Sheet1'[COVRG_CD] <> "Z1" && 'Sheet1'[PLAN_TYPE] = "10", "1",
        'Sheet1'[COVRG_CD] = "X1" && 'Sheet1'[COVRG_CD] = "Y1" && 'Sheet1'[COVRG_CD] = "Z1" && 'Sheet1'[PLAN_TYPE] = "10" && 'Sheet1'[Dependent ID] <> BLANK(), "2",
        BLANK()
    )
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Nick555 

    You can try this code:

    TEST =
    SWITCH(
        TRUE(),
        'Sheet1'[COVRG_CD] in {"X1","Y1","Z1"}=FALSE() && 'Sheet1'[PLAN_TYPE] = "10", "1",
        'Sheet1'[COVRG_CD]  in {"X1","Y1","Z1"} && 'Sheet1'[PLAN_TYPE] = "10" && 'Sheet1'[Dependent ID] <> BLANK(), "2",
        BLANK()
    )

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Nick555 

    You can try this code:

    TEST =
    SWITCH(
        TRUE(),
        'Sheet1'[COVRG_CD] in {"X1","Y1","Z1"}=FALSE() && 'Sheet1'[PLAN_TYPE] = "10", "1",
        'Sheet1'[COVRG_CD]  in {"X1","Y1","Z1"} && 'Sheet1'[PLAN_TYPE] = "10" && 'Sheet1'[Dependent ID] <> BLANK(), "2",
        BLANK()
    )

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.