AND Function (DAX)

How does the AND function (DAX) work?

The AND function (DAX) accepts two arguments. As a type of logical DAX function, it will return TRUE if both arguments are TRUE; it will return FALSE, if any of the arguments is FALSE. 

AND Formula Syntax


How do you use the AND function?

We use the AND function to determine if all conditions within a test are TRUE. If you need to use the AND function on multiple expressions, you can create a series of calculations or use the AND operator to form a simpler expression.

Related Blog Posts

Related Support Forum Posts

FTE Calculation after Switch True Logic
Calculate extended sales by fiscal week with logic to determine fiscal week automatically
Complex Allocation Rules Involving Table scan and using DAX Logic

Considerations when using the AND function

This function is used to require more than one condition at the same time. AND returns either TRUE or FALSE. 

Related Video Tutorials

Formula examples using the AND function

=AND(A11, B11)

=AND(A10, B10)

=AND(A12, B12)

Related Course Modules



Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.

Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide