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")
