title: Excel Power Query: Add New Columns by pulling data from other table (Need Solution in Powerquery only)
body: <p>I am looking for solution only using power query, Because after this solution, i have some more data forming.</p>
  
  <p><img src="https://i.stack.imgur.com/7ZIHZ.jpg" alt="Please Refer Image. Click Here "></p>
  
  <p>I have sales table with multiple type of sales units.
  I want same sales table with additional columns of transforming units &amp; values to base unit and multiplied values.</p>