Forum Discussion

jcastr02's avatar
jcastr02
Post Prodigy
6 years ago

If formula based on another table

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?

 

 

Need Help

2 Replies

  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion
    6 years ago

    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

  • Watsky's avatar
    Watsky
    Solution Sage
    6 years ago

    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 )