title: Power Query Excel show values as percentage of column
body: <p>Normally, PivotTables are used to present data in a certain order. For this specific "issue" I need to present numbers and a target.
  This conflicts in Pivots as the percentage of column takes into account the target as well.</p>
  
  <p>No worries, with PowerPivot it should be possible to address this issue. So far I have been able to create a table with the following layout:</p>
  
  <pre><code>         1     2    3
  cat A    5    10    7
  cat B    10    8    9
  cat C    0     2    1
  </code></pre>
  
  <p>Where 1, 2 and 3 are the first three days of a month (for sake of simplicity rest is left out).</p>
  
  <p>I can get totals of the columns as follows:</p>
  
  <pre><code>= Table.FromRows({List.Transform({"1","2","3"}, each List.Sum(Table.Column(prevStep, _)))}, {"1","2","3"})
  </code></pre>
  
  <p>Furthermore I am able to divide each value of a column by a number:</p>
  
  <pre><code>= Table.TransformColumns(prevStep, List.Transform({"1","2","3"}, each {_, (this) =&gt;  this / 42, type number}))
  </code></pre>
  
  <p>Now I would like to replace 42 with the totals as calculated previously for the columns columns. Note that "{"1","2","3"}" will be calculated automatically in another step.</p>
  
  <p>Can someone elaborate how to achieve this? Expected result:</p>
  
  <pre><code>         1     2    3
  cat A    0.33  0.5    0.41
  cat B    0.67  0.4    0.53
  cat C    0     0.1    0.06
  </code></pre>