AND DAX Function in Power BI

The AND DAX function returns TRUE when both the arguments return TRUE, otherwise returns false.

DAX Syntax AND(logical1, logical2)

The logical_1, logical_2 are the parameters and the logical values we want to test.

Example: Let’s create a calculated column in the table.

DAX

Performance = If( AND(Sheet20[10th Marks]>450 , Sheet20[10th Marks]> 400), "Good", "Bad")

The above code can be written using && expression.

DAX

Performance = If(Sheet20[10th Marks]>450 && Sheet20[10th Marks]> 400, "Good", "Bad")
AND dax function in Power BI