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!