Forum Discussion

TechR21's avatar
TechR21
Helper V
3 years ago
Solved

Using 3 arguments with "AND" function

Is it possible to have more than 2 arguments when using  "AND" function in powerbi?

 

 

"NEwcolumn", IF ( AND(
       
        CALCULATE ( first argument ),
CALCULATE ( 2nd argument ),
CALCULATE ( 3rd argument )
) ,
        1,
        0
    )
       
   
)
 
2 works perfectly, but I need to include a 3rd argument. I tried different ways but cant seem to make it work, any ideas?