Pull column to another table based on a relationship

[lewisc2000]

Hi 

Looking for some help on the below.

I am trying to map department to email in the user table to then map the email across both tabes and pull the department to the training table. Is this possible to have a relationship between the two tables to pull this data across and have it matching?

[v-saisrao-msft]

Hi @lewisc2000,

We haven’t heard back from you regarding your issue. If it has been resolved, please mark the helpful response as the solution and give a ‘Kudos’ to assist others. If you still need support, let us know.

Thank you.

[v-saisrao-msft]

Hi @lewisc2000,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-saisrao-msft]

Hi @lewisc2000 ,
I wanted to check if you had the opportunity to review the information provided by @rosha_rosha. Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[rosha_rosha · Accepted solution]

Hi lewisc2000,

To map department from users to Training using email in Power BI:

1. In Model view, create a one-to-many relationship from users[email] (unique) to Training[email].
2. In the Training table, add a calculated column:

Department = RELATED(users[department])

This pulls department into Training for each matching email. If emails are missing, use:

Department = IF(ISBLANK(RELATED(users[department])), "Unknown", RELATED(users[department]))