Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Nested IF with AND and OR

I'm pretty new to PowerBI and I've hit a bit of a stumbling block when it comes to nested if's with AND and OR's.  I've had a good look at previous posts and I'm even more confused as I've seen comme...
  • MFelix's avatar
    MFelix
    8 years ago

    Hi Anonymous,

     

    You should take a look at the SWITCH statment (link) to do your IF instead of doing nested IF.

     

    Regarding the AND you should use &&  for the OR you should use the || as divider.

     

    Regards,

    MFelix

     

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

Without sample data, your IF is going to look something like:

 

IF (
	AND (
		OR (
			OR (
				SEARCH("Pass",[Column 1],1,0),
				SEARCH("Intermediate Award",[Column 1],1,0)
			   ),
			SEARCH("Proceed Carry",[Column 1],1,0)
		   ),
		[Column 2] = "Did not return"
	    ),
        "Eligible to Return",
        "Not Eligible"
    )