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] = "U...
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))
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))