Multiple IF conditions in M code

[L_G]

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

[L_G · Accepted solution]

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

[L_G · Accepted solution]

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 · Accepted solution]

@L_G , alternative syntax

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