Switch Statement Not Evaluating Properly

[Nick555]

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()

    )

[Nick555]

Many Thanks! This worked perfectly! 

[Anonymous · Accepted solution]

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.