title: How to to solve divide by zero error (NaN - Not a Number) in my formula in Power BI?
body: <p>I have a column with a formula which reads:</p>
  
  <pre><code>Utilisation (Excl. Time-off) = Utilisation_Excl_Timeoff[Billable Hours]/(Utilisation_Excl_Timeoff[Available Hours] - Utilisation_Excl_Timeoff[Timeoff Hours (Excl. Public)])
  </code></pre>
  
  <p>It gives me a "NaN" error in my calculated column for some of the cells due to divide by zero.</p>
  
  <p>I would like to replace the <code>NaN</code> with a <code>0%</code> instead so that the column displays correctly in my matrix chart.</p>