How to to solve divide by zero error (NaN - Not a Number) in my formula in Power BI?
<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>