If formula based on another table

[jcastr02]

I have a master list of team members email address of whom need to complete a task.  I have another table that is showing completion of a process with a task outcome column.  I'd like to add a column where it shows 0 if they have not completed (task outcome=pending OR in progress, and 1 if they did complete (if the task outcome shows completed).  See screen shot example below.  

Both queries would be in POWER BI - Assumming I would need to build a relationship with the "email address" of both tables in order for this to work?

[Watsky]

I would join the tables on e-mail address (as long as your master doesn't include duplicates) then created a calculated column 

=IF ( Task [Task Outcome] = "Approved" , 1 , 0 )

[Nathaniel_C]

Hi @jcastr02 ,
Depending on the relationship that is built, you would either use a RELATED() or RELATEDTABLE(), or you might use LOOKUPVALUE().
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel