Forum Discussion

L_G's avatar
L_G
Helper I
5 years ago
Solved

Multiple IF conditions in M code

Hi everyone,

I need some help with the transaltion from DAX to M code.

I created a calculated column by using this DAX expression:

 

= IF(
        (Table[Column1] = "COGE" && Table[Column2] = "Utilizzo" && Table[Column3] = 1),

        1,

        0

   )

 
I tried to translate it in many different ways, but if I try to use more than 2 conditions in the IF statement, It always returns an error
Can anyone help me with this issue??
Thanks in advance
Luca
Need Help
  • L_G's avatar
    L_G
    5 years ago

    I solved the issue!

    there was a syntax error..

    By the way, I found out that you can use "and" more than 2 times in your if statement, not as it does in DAX.

     

    = if Table[Column1] = "COGE" and Table[Column2] = "Utilizzo" and Table[Column3] = 1 then 1 else 0

     

  • CNENFRNL's avatar
    CNENFRNL
    5 years ago

    L_G , alternative syntax

    #"Added Column" = Table.AddColumn(#"Previous Step", "Result", each Number.From([Column1] = "COGE" and [Column2] = "Utilizzo" and [Column3] = 1))

2 Replies

  • L_G's avatar
    L_G
    Helper I
    5 years ago

    I solved the issue!

    there was a syntax error..

    By the way, I found out that you can use "and" more than 2 times in your if statement, not as it does in DAX.

     

    = if Table[Column1] = "COGE" and Table[Column2] = "Utilizzo" and Table[Column3] = 1 then 1 else 0

     

    • CNENFRNL's avatar
      CNENFRNL
      Community Champion
      5 years ago

      L_G , alternative syntax

      #"Added Column" = Table.AddColumn(#"Previous Step", "Result", each Number.From([Column1] = "COGE" and [Column2] = "Utilizzo" and [Column3] = 1))