Forum Discussion
How to clear off Infinity and NaN value?
Hi. I wanted to create another column based on this column. I understand that NaN & infinity is because my calculations are when 0 divided by value, if I'm not mistaken, right? So what ...
PhilipTreacy amitchandak It doesn't work for me. Maybe because to get to this formula, I have 3 other formulas that use division to get to this final formula. Can I just create an if-statement? Just so that I can put them side by side. One showing NaN/Infinity, next showing it was replaced by 0(like the picture below)?
- amitchandak
Super User
Anonymous ,Can you share a sample pbix after removing sensitive data.
amitchandak PhilipTreacy This is my pbix link. The output should be the same as picture shown before. Glad if you would be able to help me https://1drv.ms/u/s!AoKh3nlpMpSOgmH-Lf_mTn3W2gXy?e=ZzkwS7
