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: https://www.arithmix.com/knowledge/measures-everyone-should-know