Forum Discussion

Spencer's avatar
Spencer
Helper II
10 years ago
Solved

IF Function - 2 Conditions,

Hi I’m trying to add multiple conditions to an IF function within a calculated column in order to register an employees status as either active or inactive.   The way I’m determining Status is via ...
Need Help
  • KGrice's avatar
    KGrice
    10 years ago

    Yes, you're on the right track with related. Assuming your InactiveEmployees table doesn't have duplicates, you'll want to create a relationship between the EmployeeMaster and InactiveEmployees tables on the employee_no field.

     

    From the Home tab, go to Manage Relationships. If it didn't autodetect it and create it for you already, click New, select EmployeeMaster in the top and InactiveEmployees in the bottom table drop-downs, select the employee_no field in both tables, and set the Cardinality to Many to One.

     

    With the relationship in place, you can adjust your formula:

     

    Status = IF('EmployeeMaster'[reason_code]=BLANK() && RELATED('InactiveEmployees'[inactive_date])=BLANK(),"Active​","Inactive")
KGrice's avatar
KGrice
Memorable Member
10 years ago

Yes, you're on the right track with related. Assuming your InactiveEmployees table doesn't have duplicates, you'll want to create a relationship between the EmployeeMaster and InactiveEmployees tables on the employee_no field.

 

From the Home tab, go to Manage Relationships. If it didn't autodetect it and create it for you already, click New, select EmployeeMaster in the top and InactiveEmployees in the bottom table drop-downs, select the employee_no field in both tables, and set the Cardinality to Many to One.

 

With the relationship in place, you can adjust your formula:

 

Status = IF('EmployeeMaster'[reason_code]=BLANK() && RELATED('InactiveEmployees'[inactive_date])=BLANK(),"Active​","Inactive")