IF statement with multiple conditions

[Anonymous]

Hi,

I need help with syntax to construct this statement:  If [date]>0, AND measure1="one" or measure1="two" or measure1="three", then "no", else "yes".

In other words, if the 1st condition is met (ie, if there is a date, then the event has already happened) and the 2nd condition meets one of 3 criteria, then no, otherwise yes.  I'm having trouble incorporating the "AND" into my IF statement. 

My goal is to have a column with either yes or no, with no blanks so that my slicer won't have the "blank" option. Thanks for your help! 

[jdbuchanan71]

Hello @Anonymous .  Give this a try.

IF ( [Date] > 0 && ( [Measure1] = "One" || [Measure1] = "Two" || [Measure1] = "Three"), "no", "yes")

&& = AND

|| = OR 

[Anonymous · Accepted solution]

That worked perfectly!  Thank you very much!  As I suspected, my statement was needlessly complicated.