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,

 

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.