title: Random Number in Power Query with query folding
body: <p>I need to generate a column of random numbers in power query. Each row has to have a new value.</p>
  
  <p>Is there a way to do this without breaking query folding??</p>
  
  <pre><code>Number.Random()
  </code></pre>
  
  <p>returns the same random value for all rows in the table (until query folding is broken)</p>
  
  <pre><code>Number.RandomBetween(x+[index]-[index], y)
  </code></pre>
  
  <p>breaks query folding.</p>
  
  <pre><code>List.Random(1, SEED){0})
  </code></pre>
  
  <p>only works (i.e. doesn't break query folding) with a static seed, which kind of defeats the purpose... </p>
  
  <p>Any suggestions as to how I can go about doing this would be greatly apreciated?</p>
  
  <p>Cheers,</p>
  
  <p>Oscar</p>