Forum Discussion
TechR21
3 years agoHelper V
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?
Hi TechR21,
You could use && instead of AND():
IF ( <condition 1> && <condition 2> && <condition 3>, 1, 0 )Best Regards,
Alexander