title: PowerBI - Lookup by Multiple Criteria
body: <p>I'm a new PBI user and would like help on the following:</p>
  <p>I have 2 tables (Table 1 &amp; 2). Table 1 is a bookings report showing sales orders, part numbers and order value. Table 2 is a margin report showing sales orders, part numbers with additional descriptive text and margin value.</p>
  <p>I would like to copy margin values from Table 2 into a new column in Table 1 by looking up by sales order and part number.</p>
  <p>Any help would be appreciated!</p>
  <p>Tables<a href="https://i.stack.imgur.com/gwyTt.png" rel="nofollow noreferrer">1</a></p>