Forum Discussion

nicktayl's avatar
nicktayl
Icon for Helper I rankHelper I
9 years ago
Solved

Too many arguments were passed to the AND function. The maximum argument count for the function is 2

    In Access and Excel you can write "AND" or "OR" functions with unlimited conditions. Is this not the case in Power BI DAX "AND" functions? If this is a limitation in DAX, does anyone have a...
Need Help
  • OwenAuger's avatar
    OwenAuger
    9 years ago

    nicktayl

    In Power BI, the DAX functions AND and OR each take exactly two arguments.

     

    To handle more than two arguments, use && for "and" and || for "or" (or nest as in earlier post).

    e.g. A && B && C

osei's avatar
osei
New Member
3 years ago

After adding the 3rd "if" condition (the bolded text in the formula below), excel is telling me that "you have entered too many arguments for this function", please what should I do

=IF(AND(J46>0,N41>0),DEGREES(ATAN(2*J46/N41)),IF(AND(J46>0,N41<0),(DEGREES(ATAN(2*J46/N41))+180)),IF(AND(J46<0,N41>0),360+DEGREES(ATAN(2*J46/N41))))/2