Adding a column with values from different tables based on a condition

Hi Ammar-Jaradat ,

You need to create a STAR SCHEMA data model.

1) Create an employee dimension table - a table that contains a unique list of all employees (names and/or ID numbers).

2) Apply all your tables to the data model and make the following relationships:

- dimEmployee[E'ee Name or ID] ONE : MANY closedItems[E'ee Name or ID]

- dimEmployee[E'ee Name or ID] ONE : MANY completionPct[E'ee Name or ID]

- dimEmployee[E'ee Name or ID] ONE : MANY satisfactionPct[E'ee Name or ID]

3) Use dimEmploye[Name] in your visuals and bring in the fact metrics from each of your fact tables.

Reference:

https://docs.microsoft.com/en-us/power-bi/guidance/star-schema 

Pete