Using 3 arguments with "AND" function

[TechR21]

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?

[mlsx4]

Hi!

You can use the operator &&

[barritown · Accepted solution]

Hi @TechR21,

You could use && instead of AND():

IF ( <condition 1> && <condition 2> && <condition 3>, 1, 0 )

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian