Forum Discussion
Solved
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]="s...
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 , 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.