Expression.Error: The name 'IF' wasn't recognized. Make sure it's spelled correctly
<p>I am trying to use <code>if else</code> query in PowerBI</p>

<p>Below is my query</p>

<pre><code>=IF(([Status]=100000004),"hello","world")
</code></pre>

<p>But this is not working</p>

<p>It says </p>

<blockquote>
  <p>Expression.Error: The name 'IF' wasn't recognized.  Make sure it's
  spelled correctly.</p>
</blockquote>

<p>What I want to achieve is,</p>

<pre><code>IF([status]=11,"Open")
else if([status]=12,"Close")
else ("reject")
</code></pre>