Forum Discussion
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!
- Anonymous7 years ago
That worked perfectly! Thank you very much! As I suspected, my statement was needlessly complicated.
2 Replies
- jdbuchanan71Super User
Hello Anonymous . Give this a try.
IF ( [Date] > 0 && ( [Measure1] = "One" || [Measure1] = "Two" || [Measure1] = "Three"), "no", "yes")
&& = AND
|| = OR
- AnonymousNot applicable
That worked perfectly! Thank you very much! As I suspected, my statement was needlessly complicated.