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