Realizing Excel Formula in PBI

[EugeniaBochko]

Hello! Is anybody know how to realize such a formula in PBI?
I have 3 columns with 0 and 1. I need to create additional columns with these conditions:

Add'l Col = IF(AND(Col1=0, Col2=0, Col3=0), 0, 1)

Col1	Col2	Col3	Add'l Col
0	1	0	1
1	1	0	1
0	0	0	0

Thank you for your help!

[MFelix · Accepted solution]

Hi @EugeniaBochko ,

In DAX the AND only allows 2 parameters use the && as AND variation add the following column:

Column = IF('Table (2)'[Column1] = 0 && 'Table (2)'[Column2] = 0  && 'Table (2)'[Column3] = 0 ; 0 ; 1)

Should return expected result.