Custom Column IF Function not recognized

[jdellamag]

Hi,

Based on the table below, can anyone help me write a custom column formula that will act as an IF function?  Every time I try an IF statement, I am told that PowerBI does not recognize the IF term

• IF  SEARCH_CLASSIFICATION__C = "Leadership Search" AND THIRD_BILL__C = TRUE,  THEN 1, ELSE 0
• IF  SEARCH_CLASSIFICATION__C = ("Academic" OR "Pediatric" OR "C-Suite")  AND TS2__CLOSED_REASON__C = "Placed First Panel",  THEN 1, ELSE 0

Thank you in advance!

[rsbin · Accepted solution]

@JD ,

if function is power query is case sensitive.  Your first one should work like this.

if ( [Search_Classification_C] = "Leadership Search" 
and [Third_Bill_C] = "True" )
then 1 
else 0

Think you should be able to follow the same syntax for your second bullet.

In future, please post data sample as text, not as a picture.  Will help make it easier to solve your issues.

Hope this helps.

Regards,