Forum Discussion
Realizing Excel Formula in PBI
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!
Hi Anonymous ,
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.
1 Reply
Hi Anonymous ,
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.