What is it?
Use IF for conditional logic (like a traditional IF THEN ELSE) to compare one measure against another and then perform an action. You can nest IF (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((Table.MeasureA>=Table.MeasureB), Table.MeasureC, Table.MeasureD)
Example:
Example = IF(Sales rep.Rep tenure in months>12),Rep drivers.Rep ramp, 1)
Will result in the sales reps ramp (representing an adjustment based on their initial period in a new role) being 1 (100%) if the rep’s tenure exceeds 12 or a driver called Rep ramp (e.g. 10%, 50%) if less than 12.
Related measure: Arithmix Functions: IF AND (conditional logic IF AND THEN ELSE)
Knowledge Base link: https://www.arithmix.com/knowledge/measures-everyone-should-know