Cheat Sheets/Power BI/AND &&
DAX function

AND && — DAX function reference

All conditions true.

Syntax

dax
AND(<logical1>, <logical2>)    <logical1> && <logical2>

Examples

dax
[Active] && [Approved]
→ true / false
dax
AND(Sales[Amount] > 0, Sales[Quantity] > 0)
→ true / false

&& chains any number of conditions; nesting AND() calls to do the same is much more verbose.

dax
Sales[Amount] > 0 && Sales[Region] = "West" && NOT(ISBLANK(Sales[CustomerID]))
→ true / false

Common mistakes & gotchas

Related DAX functions

From Logical & error handling

← Back to the Power BI (DAX) cheat sheet