Transcoding column values from one table to another

Hello everyone, 

I have multiple tables in my model that contain binary values or codes that need to be translated to a corresponding label. For example, I have a client table, where the type can be 0 or 1, which means "Loyal" and "Other", or a country table where if the value is 1, it's France, if 2, it's England, 3 is Germany, etc. 

I have a table that I want to use to transcore these values that looks like this :

My goal was to join the transcoding table to my other tables on the code, with the condition that the entity is the right name. In SQL, I would type :

select Label from transcode

where transcode.Code = Client.client_type

and transcode.Entity = "Client";

But I don't know how to achieve this in Power BI so that I can use labels instead of the codes in each table to build my report. 

Thank you all !