Forum Discussion

Thorstedt's avatar
Thorstedt
Regular Visitor
7 years ago
Solved

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;...
Need Help
  • 101Mathew's avatar
    101Mathew
    7 years ago

    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's avatar
Thorstedt
Regular Visitor
7 years ago

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's avatar
101Mathew
Advocate V
7 years ago

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's avatar
    Thorstedt
    Regular Visitor
    7 years ago

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