Getting the value from one table to add to another

[Dan_at_TWE]

I have 2 tables.

One table has many individual transaction records each containing an employee's name and other data.   

Another table is an employee data table containing the employee's name and their initials.

There is a one to many relationship from the employee's name field in employee data table to the employee's name in the individual transactions records table.

I want to bring over the particular employee's intials from the employee data table and add their initials to their transaction records so I can use their initials on the transaction report, instead of their name.

ie.

1) Look at the current transaction record and find the employee's name.

2) Based on that name, find their initials in the employee info table.

3) Bring over their initials from the employee data table to the transaction record into a new column.

[bhanu_gautam · Accepted solution]

@Dan_at_TWE , You can create a new calculated column for this to get intials using Related function as two table have relation on the basis of employee name column

EmployeeInitials = RELATED('EmployeeData'[Initials])

[Dan_at_TWE]

Thanks.  The simplicity evaded me. LOL!

[HotChilli]

calculated column using RELATED to get the value from the dimension table?