title: How can I transform a table with only ONE cell into a simple value?
body: <p>For example: if I just have this table</p>
  
  <pre><code>---------
  | power |
  ---------
  | 100   |
  ---------
  </code></pre>
  
  <p>I just want the value 100 (a number in this case). And if for example, the value is a string I want to have the value of the string too.</p>
  
  <p>I need this to incorporate this subquery into another query, more precisely in a condition function.</p>
  
  <p>PS: I use M language (Power Query in POWER BI Desktop)</p>