IF with &&& and ||

[KW123]

Hi! 

I have searched for awhile and I can't seem to find a solution.... I have a dashboard matrix which is broken out by Month in the columns.  Underneath each month is a ranking (from 1st - 200th depending on the month), a name,  # in sales, and $ in sales.  Each month there is a set of "favorite names" and they change depending on the month.  I need to be able to highlight those names within the month and I was thinking if I made some sort of DAX to distinguish these favorite names, I can do a conditional rule where that name is highlighted yellow. 

Basically the DAX that I am trying to build would go something like this: 

IF [month] = "January" OR "February"" AND [favorite name] = "John" or "Sam" or "Joe" (etc), then "F" else blank
IF [month] = "March" OR "APRIL" OR "MAY" AND [favorite name] = "Sue" OR "Anne" OR "Rose" then "F" else blank

ETC for each month.  

Thank you! 

[SachinNandanwar · Accepted solution]

You could use a SWITCH statement

SWITCH(
TRUE(), 
(month = "January" || month = "February") &&  [favorite name] IN {John,Sam,Joe},
.
.
BLANK()
)

You can refine the above syntax.

[AlexisOlson · Accepted solution]

As @SachinNandanwar points out, using both SWITCH ( TRUE(), ... ) and IN syntax will help with this:

SWITCH (
    TRUE (),
    [month] IN { "January", "February" }
        && [favorite name] IN { "John", "Sam", "Joe" }, "F",
    [month] IN { "March", "April" }
        && [favorite name] IN { "Sue", "Anne", "Rose" }, "F",
    [ ... ],
    BLANK ()
)

DAX - The Diabolical Genius of “SWITCH TRUE” - P3 Adaptive

[SachinNandanwar · Accepted solution]

You could use a SWITCH statement

SWITCH(
TRUE(), 
(month = "January" || month = "February") &&  [favorite name] IN {John,Sam,Joe},
.
.
BLANK()
)

You can refine the above syntax.