Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (11.1k points)

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 

1 Answer

0 votes
by (22.5k points)

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     

Related questions

0 votes
1 answer
asked Nov 26, 2020 in BI by Chris (11.1k points)
0 votes
1 answer
asked Nov 21, 2020 in BI by Chris (11.1k points)
0 votes
1 answer
0 votes
1 answer
asked Dec 26, 2020 in BI by Chris (11.1k points)
0 votes
1 answer

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...