If and multiple conditions

[devika]

I'm creating a column with 'And' ,'Multiple Conditions'

Co = IF(and[RRR]=1, ([Highest]="Rer" or [Highest]="Con" or [Highest]="EC") then 1 else 0)

I worked out for single conditon but trying to tackle multiple conditions. any help would be great, thanks

Co = IF(AND([RRR]=1, [Highest]="Rer"),1,0)

[amitchandak]

@devika , if you are trying on power Query/M

Co = if [RRR]=1 and ([Highest]="Rer" or [Highest]="Con" or [Highest]="EC") then 1 else 0

or

Co = if [RRR]=1 and [Highest] in {"Rer" , "Con" ,"EC" }  then 1 else 0

In DAX a new column

Co = IF([RRR]=1 && [Highest] in {"Rer" , "Con" ,"EC" } , 1 , 0)

[devika]

I managed to solve by Switch(true(), [rrr]=1 && [Highest] ="Rer",1,[rrr]=1 && [Highest] ="Con",1,0)

I will yours solution too and post it here. thanks for you reply

[littlemojopuppy · Accepted solution]

Hi.  Try this...

IF(
	AND(
		[RRR] = 1,
		[Highest] IN {"Rer", "Con", "EC"}
	),
	1,
	0
)

[devika]

Something around IN Operator is not right.

Getting Token Comma Expected error... not sure what is missed

[littlemojopuppy]

Can you paste your code?  I tried it in another project and worked perfectly