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

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

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

        Hi Anonymous 

        Do you use Power BI Desktop of Power BI Report server?

        You can see the supported system where Power BI Desktop can be installed.

         

        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.