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),...
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.
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.