Forum Discussion

chotu27's avatar
chotu27
Icon for Post Patron rankPost Patron
6 years ago
Solved

Muliple if Condition with multiple conditions

Hi All,   Ignatkovkir    Below is the sample data Column 1       Column2 EMEN -OTT OLX EIN -OTT OLX EMEN -OTT OIA ANIN -OTT TRS EMEN -OTT BHT EMEN -OTT STA EMEN -OTT ...
data protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    Hi, chotu27 

     

    Based on your description, you may try the following formulas.

     

    formula1 = 
IF(
    OR('Table'[Column2]="OLX",'Table'[Column2]="TRS")&&
    LEFT('Table'[Column1],4)="EMEN",
    "State Covered",
    IF(
        OR('Table'[Column2]="OIA",'Table'[Column2]="BHT")&&
        LEFT('Table'[Column1],4)="EMEN",
        "State Covered",
        IF(
            OR('Table'[Column2]="STA",'Table'[Column2]="STI"),
            "Current State",
            "not covered"
        )
    )
)
    formula2 = 
SWITCH(
    TRUE(),
    OR('Table'[Column2]="OLX",'Table'[Column2]="TRS")&&LEFT('Table'[Column1],4)="EMEN","State Covered",
    OR('Table'[Column2]="OIA",'Table'[Column2]="BHT")&&LEFT('Table'[Column1],4)="EMEN","State Covered",
    OR('Table'[Column2]="STA",'Table'[Column2]="STI"),"Current State",
    "not covered"
)

     

     

    Result:

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

I doubt on few and condition, but you can get like

 

if(table(colum2) in {"OLX", "TRS"} && table(colum2) =  in {"OIA", "BHT"} &&  search("EMEN",table(colum1),1) >0 , "State coverd" 
, if(table(colum2) in {"STA","STI"} , "Current State" ,  "not covered"))


if(table(colum2) in {"OLX", "TRS","OIA", "BHT"} &&  search("EMEN",table(colum1),1) >0 , "State coverd" 
, if(table(colum2) in {"STA","STI"} , "Current State" ,  "not covered"))

 

Or use use Switch True

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin