Forum Discussion

christianfcbmx's avatar
christianfcbmx
Post Patron
8 years ago

IF Function Combined

Dear Community I have a question:

I want to use an "If" function but also need to filter by an specific status from another column ("Green", "Yellow" , "Red"), in this case "Red"... (all in the same formula)

Im doing this but I dont know how to continue:


Column 1 = IF('EXTR-INC&WO-(Chil'[Sta]="Asigned",1 ,IF('EXTR-INC&WO-(Chil'[Sta]="In Progress",1 ,IF('EXTR-INC&WO-... (Im Converting into "1" those status as you see as long as the other column that I have named "condition" said "Red" ..it is too complicated?

Any advice will be so much appreciated!

 

 

General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

1 Reply

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    HI christianfcbmx

     

    If the search is with a single Column you can shorten the CODE by using the "IN" operator

     

    =
IF (
    'EXTR-INC&WO-(Chil'[Sta] IN { "Asigned", "In Progress" }
        || 'EXTR-INC&WO-(Chil'[Column] IN { "__", "__" },
    1,
    ___
)