Arithmix Functions: IF AND (conditional logic IF AND THEN ELSE)

What is it?
Combine IF with AND for conditional logic (like using AND in a traditional IF THEN ELSE) to compare two measures against two other measures and then perform an action. You can nest IF and AND (for multi-step conditionals) and combine with other functions.

Comparisons include <, >, <=, >= and ==.
Note: “==” in Arithmix is currently used versus “=” (equals) in a spreadsheet.

How to write it?
Fx layout: = IF(AND(Table.MeasureA1==Table.MeasureB1,Table.MeasureA2>Table.MeasureB2), Table.MeasureC, Table.MeasureD)

Example = IF(AND(Sales rep.Rep tenure>12,Sales rep.Rep profile==‘Experienced’),Rep drivers.Rep quota*Rep drivers.Experienced rep uplift,Rep drivers.Rep quota)
Will result in the sales rep’s quota being uplifted by a driver (based on if we’ve tagged the rep as “Experienced”) or remaining at the standard rep quota level once the rep’s tenure exceeds 12 months.

Related measure: Arithmix Functions: IF (conditional logic IF THEN ELSE)

Knowledge Base link: