title: Power Query: transform a column by multiplying by another column
body: <p>I want to do something similar to <a href="https://stackoverflow.com/questions/31548135/power-query-transform-a-column-based-on-another-column">Power Query Transform a Column based on Another Column</a>, but I'm getting stuck on how to modify the syntax for my particular goal.</p>
  
  <p>Similar to the linked question, assume that I have the following table:</p>
  
  <pre><code>Table 1:
  Column A | Column B | Column C
  ------------------------------
   1       | 4        | 7
   2       | 5        | 8
   3       | 6        | 9
  </code></pre>
  
  <p>Instead of changing the value of the Column A conditional on Column B, I want to multiply the values in multiple columns (Column B and Column C) by those in Column A and replace the values in the initial columns so that I can get the following:</p>
  
  <pre><code>Table 1:
  Column A | Column B | Column C
  ------------------------------
   1       | 4        | 7
   2       | 10       | 16
   3       | 18       | 27
  </code></pre>
  
  <p>Is this possible to do without using multiple sequences of <code>Table.AddColumn</code> followed by <code>Table.RemoveColumns</code>?</p>
  
  <p>I have also tried <code>Table.TransformColumns</code> based on <a href="http://blog.crossjoin.co.uk/2013/04/16/applying-a-function-to-every-cell-in-a-table-in-data-explorer/" rel="nofollow noreferrer">this</a>, but not been able to get the syntax right to achieve this.</p>