If then else condition multiple statements after then

[jasmine9]

Hi,

1. Based on my If condition, can I change the value of a different column?

For eg: if (pet = cat) then var1 = animal 

2. In my If condition, I want to be able to write multiple statements both under "then" and "else".

Is this possible in PowerQuery or PowerBI and if not, what is the alternative?

For eg:  if (pet=cat) then {var1=animal ; var2= mammal; }  else { var1= noncat; var2="nonmammal"} 

Thanks,

Jas

[v-kelly-msft · Accepted solution]

Hi @jasmine9 ,

Use "switch" function for each var,see below link:

https://docs.microsoft.com/en-us/dax/switch-function-dax

You may take below example for instance:

Measure for var1=Switch(
True(),
MAX([Pet])="cat","animal",
"noncat")
 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Ashish_Mathur]

Hi,

You cannot do it al in one formula.  You will have ot use 2 formulas - one each for var1 and var2.