Trying to write an IF statement using OR

[Antonio195754]

Greetings,

I'm trying to write a statement for a column that shows 3 types of values: Complete, Not Complete, Not Assigned.

I need both "Complete" OR "Not Assigned" to return a "0", else "1".

I can write =if('Database'[Column]="Complete","0","1")) And that returns a 0 anytime it shows complete.  What i can't get in one statement is for it to return a zero if it sees "Complete" or "Not Assigned" in the column.

Is that possible?

[Greg_Deckler]

Column = if('Database'[Column]="Complete" || 'Database'[Column]="Not Assigned","0","1"))

[Antonio195754]

@Greg_Deckler This method also worked for me.  all my visuals that hinged to that missing link then worked.  thanks so much

[Greg_Deckler]

Yeah, they are equivalent. I just find the || and && easier because as I am thinking through the logic, that's how I think, if this or that... not "if well let's see it will be this or that so I need to start with OR".

Rubbish!! 🙂

[Ashish_Mathur · Accepted solution]

Hi,

Try this calculated column formula

=if(OR('Database'[Column]="Complete",'Database'[Column]="Not Assigned"),0,1)

Hope this helps.