Forum Discussion
Pull column to another table based on a relationship
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?
Hi lewisc2000,
To map department from users to Training using email in Power BI:
- In Model view, create a one-to-many relationship from users[email] (unique) to Training[email].
- 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]))
4 Replies
rosha_roshaResolver II
Hi lewisc2000,
To map department from users to Training using email in Power BI:
- In Model view, create a one-to-many relationship from users[email] (unique) to Training[email].
- 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]))
v-saisrao-msftCommunity Support
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.- 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,
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.