DAX AND Function

The DAX AND function in Power BI is used to perform a logical conjunction on two expressions. It returns TRUE if both expressions evaluate to TRUE, and FALSE otherwise. This function is useful for combining multiple conditions in DAX formulas.

Syntax:

AND(<logical1>, <logical2>)

<logical1>: The first condition to evaluate.

<logical2>: The second condition to evaluate.

Purpose:

The AND function allows you to test multiple conditions simultaneously and return TRUE only if all specified conditions are TRUE. This is essential for scenarios where you need to ensure that multiple criteria are met before proceeding with a calculation.

Example:

Consider the following "Sales" table with columns "Product", "SalesAmount", and "Cost". You can use the AND function as follows:

HighProfit = AND(Sales[SalesAmount] > 150, Sales[Cost] < 100)

Example Scenario:

Assume you have the following "Sales" table:

                                                         

Using the AND function, you can flag high revenue and high unit sales:

HighProfit = AND(Sales[SalesAmount] > 150, Sales[Cost] < 100)

The resulting table would be:

Using the && Operator:

The AND function can also be written using the && operator, which serves the same purpose but with a more concise syntax.

The above example using the && operator:

HighProfit = IF(Sales[SalesAmount] > 200 && Sales[Cost] < 100,"True","False")

Combining AND with IF Functions:

For a more meaningful result, we can combine the AND function with the IF function:

HighProfit_IF = 

IF(AND(Sales[SalesAmount] > 150, Sales[Cost] < 100), "High Profit", "Not High Profit")

                                               

In this example, none of the rows meet both conditions (SalesAmount > 150 and Cost < 100), so all rows are labeled "Not High Profit." If there were rows meeting both conditions, those rows would be labeled "High Profit."