title: "Subquery" in Power BI
body: <p>I have two tables.</p>
  
  <p><a href="https://i.stack.imgur.com/xMVTN.png" rel="nofollow noreferrer">Table 1</a> </p>
  
  <p><a href="https://i.stack.imgur.com/ueyVG.png" rel="nofollow noreferrer">Table 2</a></p>
  
  <p>As you can see, there is a link between ID from Table 1 and IdPays from Table 2 (the link is obviously the letter A,B,...). My question is, is it possible to make a link between the two tables without having to duplicates any column ? Is it possible to create a link immediately on the letter of the ID column ?</p>
  
  <p>Thanks for your help.</p>