Forum Discussion
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...
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]))
rosha_rosha
Resolver II
Resolver IIHi 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]))