cancel
Showing results for
Did you mean:
Regular Visitor

## Is it possible to have an If function in another If function

Hi

I'm interested in moving this DAX formular into Power Query:

S1 = IF(IF('STATUS 1'[t2s1q4] >2;1;0)+If('STATUS 1'[t2s1q5] >2;1;0)+If('STATUS 1'[t2s1q11] >2;1;0)+If('STATUS 1'[t2s1q12] >2;1;0)+if('STATUS 1'[t2s1q13] >2;1;0)+if('STATUS 1'[t2s1q14] >2;1;0)+if('STATUS 1'[t2s1q15] >2;1;0) >2;TRUE;FALSE)

It is an If function with multiple If functions within it: If(if + if + if ..) then, else - I am using it to measure If different test scores are above a certain limit (>2) and finally If >2 of these tests are above that limit. All the STATUS tables range from 1-5.

Is this possible in Power Query, as it is in DAX?

I'm fairly new to M, so this might be a newbie question. I would appreciate any help!

1 ACCEPTED SOLUTION
Resolver II

Please note, you can also use "and" "or".  An example of a simple one:-

If

(

[Column1] = "A"

and

[Column2] = "B"

)

then "Confirmed A & B"

else if

"not A&B"

else

"something else"

4 REPLIES 4
Memorable Member

Hi @Thorstedt,

jop, it is possible. Just add a new column in PowerQuery Editor UI and rewrite your many ifs. A documentation for IF can be found here: https://docs.microsoft.com/en-us/powerquery-m/expressions-values-and-let-expression#If

Regular Visitor

Hi @Nolock

Thanks, I figured out the different formulation: If((if [a] >x THEN y ELSE z)+(If [b] >x THEN y ELSE z) .... ) >x THEN "True" ELSE "False")

Thanks!

Resolver II

Please note, you can also use "and" "or".  An example of a simple one:-

If

(

[Column1] = "A"

and

[Column2] = "B"

)

then "Confirmed A & B"

else if

"not A&B"

else

"something else"

Regular Visitor

That might be a simpler solution than my first attempt. Thanks!

Announcements

#### Launching new user group features

Learn how to create your own user groups today!