PowerBI mapping between sources

Hi,

I'm a new user to PowerBI and have come up stuck trying to create a new project, as outlined below.


Table 1 has film names in variation (e.g. The Post).
Table 2 has film names in another variation (e.g. Post, The), but also has a unique title number.

I have mapping table from Excel that has the unique title numbers (Table 2) in one column, and the Table 1 film names in the other column.

I’ve added all 3 tables to my PowerBI project, but I am struggling to know how to get them to talk to each other. I’ve created the relationships, but I still can’t pull data from Table 2 using the film names from Table 1.


What am I doing wrong / do I need to create extra measures or columns? Do I need to append queries or something like this?

Thanks!