IF OR function

[olops2002]

Hi Everyone,

Please i am trying to use IF(OR) function to turn the values of  a new column to "vg" if the values of column 1 is "vot", or column 2 is "umc" or column 3 is "medical case"  etc.Its seems if(or) function here iun power bi only considers 2 columns if i am correct. Any help will be appreciated

Seyi

[olops2002]

HI Nishudhan,

Thanks for your support..I will try it now and revert on my findings.

Thanks once again Nishudhan.

[Nishudhan · Accepted solution]

Hi ,

As you know OR function can take only 2 conditions . So for the more than two condition you need to use "||".like this,

IF(OR) = IF('Base Data'[Bill Type] = "vot"||'Base Data'[Bill Type]="umc"|| 'Column3'="medicalcase","Yes","No")

[olops2002]

HI Nishudhan,

You are the best.I t works so well. Thanks for the knowledge shared.