Getting useful data from another table

[oberkery]

The file I am working with has data from one table with an ID number (ctp), then on another data set I have the same ID numbers (ID) with their location names(name). What I'm trying to do is have the locations be put on the original table next to their correlating ID numbers. I'm not sure how to get this to work in the power bi tables. I've tried dax expressions but haven't found and success. Feedback would be greatly appreciated.

This table has the dealID that I am trying get the location names for.

This is the original table

This table has the (ID) numbers that correlate with the (ctp) numbers from the previous table, and I want to create a function that returns the names on the previous table.

This is the table that converts the ctp number to the location

[Anonymous · Accepted solution]

Have you tried creating a calculated column using the LOOKUPVALUE function?

Location =LOOKUPVALUE(table2[address],table2[ID],table1[ctp])

[oberkery]

Worked Thanks!

[Anonymous]

@oberkery  Great! If you could mark my response as the solution, I'd appreciate it.