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

mmace1's avatar
mmace1
Icon for Impactful Individual rankImpactful Individual
9 years ago

Can you write out an && example?  That looks like a better way, but I'm not quite following.  

 

Thanks!

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

OwenAuger Beautiful, thanks!

 

mmace1 

DAX:

Purchase Only Flag = If(tbl_kpi[Program]="Purchase" && tbl_kpi[Purchase Price]>0 && (tbl_kpi[Rehab Budget]=0 || isblank(tbl_kpi[Rehab Budget])),"Purchase Only",blank())

 

Access:

Purchase Only Flag: IIf([kpi].[Program]="Purchase" And [kpi].[Purchase Price]>0 And ([kpi].[Rehab Budget]=0 Or [kpi].[Rehab Budget] Is Null),"Purchase Only",Null)