Custom Column Query If, ands, or

[mjackson122]

Attempting to create a custom column in query however the results are always error.

I have a column called office in table 1 that I want to create a custom column from.

If[office]="A" and [size]="small" or "medium" or "large"

then "normal"

else "xlarge"

[amitchandak · Accepted solution]

@mjackson122 , Try like 

In power query

If[office]="A" and ([size]="small" or [size]= "medium" or [size]= "large")
then "normal"
else "xlarge"

or

If[office]="A" and [size] in {"small", "medium","large"}
then "normal"
else "xlarge"

in DAX

If ([office]="A" && [size] in {"small", "medium","large"} ,"normal" ,"xlarge")

[mjackson122]

Thanks the first one worked. I originally tried the second option you listed but forgot to include "in",

Thanks for your help.