How to to solve divide by zero error (NaN - Not a Number) in my formula in Power BI?

Question

I am having a column which reads

Utilisation (Excl. Time-off) = Utilisation_Excl_Timeoff[Billable Hours]/(Utilisation_Excl_Timeoff[Available Hours] - Utilisation_Excl_Timeoff[Timeoff Hours (Excl. Public)])

But it gives "NaN" in my calculated column because of dividing a number with zero,want to replace NaN with 0,To display correctly in matrix chart 

Answer 1

Use the following function

IFERROR(value, value_if_error) function can do this. MSDN

Utilisation (Excl. Time-off) = IFERROR(Utilisation_Excl_Timeoff[Billable Hours]/(Utilisation_Excl_Timeoff[Available Hours] - Utilisation_Excl_Timeoff[Timeoff Hours (Excl. Public)]), 0)

If u want to learn the tool in-depth, then come to us and sign up for this Power BI Certification