Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Multiple criteria for switch statement

I'm really struggling to get my head round this SWITCH statment, may not be possible in one calculated column? I've written it in SQL below as a case statment and it works but cant do the same in DAX...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Anonymous 
    This is a formula for a calculated column

    Switch Statement =
SWITCH (
    TRUE (),
    TableName[A] = BLANK ()
        && TableName[B] IN { 1, 2, 3, 4, 5 }, "Global",
    TableName[A]
        IN { 11, 12, 13 }
            && OR ( TableName[B] = BLANK (), TableName[B] = 6 ), "Local",
    TableName[A] = BLANK ()
        && OR ( TableName[B] = BLANK (), TableName[B] = 6 )
        && NOT ( RELATED ( DIM[C] ) IN { 98, 99 } ), "Customer",
    TableName[A] = BLANK ()
        && OR ( TableName[B] = BLANK (), TableName[B] = 6 )
        && RELATED ( DIM[C] ) = 98, "Other",
    "NA"
)
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Amazing, thank you!!