Forum Discussion

lewisc2000's avatar
lewisc2000
New Member
1 year ago
Solved

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...
Need Help
Tutorial Requests
  • rosha_rosha's avatar
    rosha_rosha
    1 year ago

    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]))

v-saisrao-msft's avatar
v-saisrao-msft
Icon for Community Support rankCommunity Support
1 year ago

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.