TechNet
Export (0) Print
Expand All

AND Function (DAX)

 

Checks whether both arguments are TRUE, and returns TRUE if both arguments are TRUE. Otherwise returns false.

Syntax

AND(<logical1>,<logical2>)

Parameters

TermDefinition
logical_1, logical_2The logical values you want to test.

Return Value

Returns true or false depending on the combination of values that you test.

Remarks

The AND function in DAX accepts only two (2) arguments. If you need to perform an AND operation on multiple expressions, you can create a series of calculations or, better, use the AND operator (&&) to join all of them in a simpler expression.

Example

The following formula shows the syntax of the AND function.

=IF(AND(10 > 9, -10 < -1), "All true", "One or more false"

Because both conditions, passed as arguments, to the AND function are true, the formula returns "All True".

Example

The following sample uses the AND function with nested formulas to compare two sets of calculations at the same time. For each product category, the formula determines if the current year sales and previous year sales of the Internet channel are larger than the Reseller channel for the same periods. If both conditions are true, for each category the formula returns the value, "Internet hit".

AND functionColumn Labels
Row Labels2005200620072008Grand Total
Bib-Shorts
Bike Racks
Bike StandsInternet Hit
Bottles and CagesInternet Hit
Bottom Brackets
Brakes
Caps
Chains
Cleaners
Cranksets
Derailleurs
FendersInternet Hit
Forks
Gloves
Handlebars
Headsets
Helmets
Hydration Packs
Jerseys
Lights
Locks
Mountain Bikes
Mountain Frames
Panniers
Pedals
Pumps
Road Bikes
Road Frames
Saddles
Shorts
Socks
Tights
Tires and TubesInternet Hit
Touring Bikes
Touring Frames
Vests
Wheels
Grand Total
= IF( AND(  SUM( 'InternetSales_USD'[SalesAmount_USD])
           >SUM('ResellerSales_USD'[SalesAmount_USD])
          , CALCULATE(SUM('InternetSales_USD'[SalesAmount_USD]), PREVIOUSYEAR('DateTime'[DateKey] )) 
           >CALCULATE(SUM('ResellerSales_USD'[SalesAmount_USD]), PREVIOUSYEAR('DateTime'[DateKey] ))
          )
     , "Internet Hit"
     , ""
     )

See Also

Logical Functions (DAX)

Community Additions

Show:
© 2016 Microsoft