Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Multiple or condition in IF statement

I need to combine 3 OR condition in if statement. PowerbI only allows 2 arguments in if statement.

In the below screenshot the yellow or condition is not taken in action as only 2 arguments is allowed in if stament.

Blocked_Approved = IF(OR (vVENDOR_PURCH_ORG_AVL[CentralPurchasingBlock] = "X",vVENDOR_PURCH_ORG_AVL[PurchBlockForPurchasingOrganization]="X", vVENDOR_PURCH_ORG_AVL[BlockedForAllEnabledPurchasingOrganization] ="X"),"Blocked","Active"
 
How can I can take 3 or statements.
Show and Tell
  • amitchandak's avatar
    amitchandak
    3 years ago

    Anonymous , I think or can take only 2 arguments

     

    Blocked_Approved = IF( (vVENDOR_PURCH_ORG_AVL[CentralPurchasingBlock] = "X" || vVENDOR_PURCH_ORG_AVL[PurchBlockForPurchasingOrganization]="X" || vVENDOR_PURCH_ORG_AVL[BlockedForAllEnabledPurchasingOrganization] ="X"),"Blocked","Active")

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Anonymous , I think or can take only 2 arguments

     

    Blocked_Approved = IF( (vVENDOR_PURCH_ORG_AVL[CentralPurchasingBlock] = "X" || vVENDOR_PURCH_ORG_AVL[PurchBlockForPurchasingOrganization]="X" || vVENDOR_PURCH_ORG_AVL[BlockedForAllEnabledPurchasingOrganization] ="X"),"Blocked","Active")