AND DAX Function

The AND 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: Create a calculated column.

DAX

New Column = IF(And('Query1 (2)'[Customer State] ="Haryana", 'Query1 (2)'[Customer Country]="India"), "My State", "Other State")

The above code can be written using && expression.

DAX

New Column = IF('Query1 (2)'[Customer State] ="Haryana" && 'Query1 (2)'[Customer Country]="India", "My State", "Other State")