Forum Discussion
Custom Column Query If, ands, or
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"
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")
2 Replies
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")
Thanks the first one worked. I originally tried the second option you listed but forgot to include "in",
Thanks for your help.
