title: PowerBI cannot convert value null to type logical when adding custom column
body: <p>Trying to make a custom column dependant on a column that consists of numerical values and null values (for bad data).
  My expression:</p>
  <pre><code>= Table.AddColumn(#&quot;Renamed Columns&quot;, &quot;Custom&quot;, each if [Value] &gt; 0.5 then 100 else if [Value] = &quot;null&quot; then &quot;null&quot; else 80)
  </code></pre>
  <p>I get the error: We cannot convert the value null to type Logical.</p>
  <p>Any suggestions? Spoofing the nulls to 0 will make my data confusing for values that may indeed be 0.</p>
  <p>Thanks in advance!!!</p>