VLookup between two tables in dax

[Rena13M]

Hello,

I am trying to do a VLookup between two tables in order to create a column that returns the result of the names of the resources present in table A but also in table B.
I tried to use the RELATED function but I got an error saying, there is no relation between my two tables and I think it's because the relation between table A and table B is a many-to-many relationship.
Does anyone know please how I could make my VLookup work?

TABLE A

TABLE B

Thank you,

Best Regards.

[Rena13M · Accepted solution]

https://www.youtube.com/watch?v=73T7isNVH_w