title: SQL to powerBI expression?
body: <p>How to write this expression in PowerBI</p>
  
  <pre><code>select distinct([date]),Temperature from Device47A8F where Temperature&gt;25
  </code></pre>
  
  <p>Totally new to PowerBI. Is there any tool that can change the query from sql to PowerBI expression?</p>
  
  <p>I have tried so many type of different type of expressions but getting error, Most of the time I am getting this:</p>
  
  <pre><code>The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.
  </code></pre>
  
  <p>Need help, Thanks.</p>