Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

IF DAX Statement

Hi,   I am looking for way to simply the following for a calculated column     Number of Interactions = if('Table 4'[Number of Weeks]=1,"1",IF('Table 4'[Number of Weeks]=2 || 'Table 4'[Number of...
Need Help
  • vanessafvg's avatar
    vanessafvg
    8 years ago

    Anonymous

    test =
    SWITCH (
    TRUE (),
    numberofweeks = 1, "1",
    AND ( numberofweeks > 2, numberofweeks < 5 ), "2-4"
    )

          

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Brill vanessafvg, is there a way though to say

 

test =
SWITCH ( numberofweeks = 1, "1",

               numberofweeks = 2 | 3 | 4 , "2-4",

etc)

 

?

 

Thanks

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
8 years ago

Anonymous

test =
SWITCH (
TRUE (),
numberofweeks = 1, "1",
AND ( numberofweeks > 2, numberofweeks < 5 ), "2-4"
)