title: I want to apply function to each row of a table in Power Query M and have list as result
body: <p>I have a table, say</p>
  <pre><code>ttt = Table.FromRecords({
          [OrderID = 1, CustomerID = 1, Item = &quot;Fishing rod&quot;, Price = 100.0, Shipping = 10.00],
          [OrderID = 2, CustomerID = 1, Item = &quot;1 lb. worms&quot;, Price = 5.0, Shipping = 15.00],
          [OrderID = 3, CustomerID = 2, Item = &quot;Fishing net&quot;, Price = 25.0, Shipping = 10.00]
        }),
  </code></pre>
  <p>I need to have a total sum Price*Shipping. I can do it like that</p>
  <pre><code>result = List.Sum(Table.AddColumn(ttt, &quot;TempColumn&quot;, each [Price]*[Shipping])[TempColumn])
  </code></pre>
  <p>Question is: can I get rid of &quot;TempColumn&quot; and make a list at once.</p>