Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

question about switch

I have a requirement where I have to match one expression with multiple values (from syntax below)   SWITCH(<expression>, <value>, <result>[, <value>, <result>]…[, <else>])   I am writing a psued...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Anonymous 

Create measures

Measure 1 = IF(ISERROR(SEARCH("tst",MAX(Sheet7[column2]),1)),0,SEARCH("tst",MAX(Sheet7[column2]),1))

Measure =
IF (
    MAX ( Sheet7[column] ) IN { "a", "b", "c", "d", "e", "f" },
    IF (
        [Measure 1] <> 0
            || MAX ( Sheet7[column] ) IN { "a", "b" },
        IF (
            MAX ( Sheet7[column] ) IN { "d", "e" },
            [use this column],
            IF ( MAX ( Sheet7[column] ) IN { "b", "d", "e", "f" }, [use this column] )
        ),
        0
    )
)

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thank you for your response

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    How can I write a calculated column, instead of a measure 

    • v-juanli-msft's avatar
      v-juanli-msft
      Community Support
      7 years ago

      Hi Anonymous 

      Create columns

      Column 2 = IF(ISERROR(SEARCH("tst",Sheet7[column2],1)),0,SEARCH("tst",Sheet7[column2],1))

Column 3 =
IF (
    Sheet7[column] IN { "a", "b", "c", "d", "e", "f" },
    IF (
        [Column 2] <> 0
            || Sheet7[column] IN { "a", "b" },
        IF (
            Sheet7[column] IN { "d", "e" },
            [use this column],
            IF ( Sheet7[column] IN { "b", "d", "e", "f" }, [use this column] )
        ),
        0
    )
)

       

      Best Regards
      Maggie

       

      Community Support Team _ Maggie Li
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Thanks, I am using visual studio 2012 version, is IN not supported there, I get error  'IN' is incorrect