Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

IF statement with multiple conditions

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! 

  • Anonymous's avatar
    Anonymous
    7 years ago

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

2 Replies

  • Hello Anonymous .  Give this a try.

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

    && = AND

    || = OR 

    • Anonymous's avatar
      Anonymous
      Not applicable

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