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

[Thorstedt]

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!

[Nolock]

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

[Thorstedt]

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!

[101Mathew · Accepted solution]

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"

[Thorstedt]

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