Forum Discussion

LaurentZ's avatar
LaurentZ
Helper I
6 years ago
Solved

How to manage NaN or Infinity in PowerQuery (no Dax) ?

Hi, Is there an easy way to manage NaN or Infinity ?   I tried to replace error, no impact. I tried to replace "NaN" by 0, no impact (when it's working with Null). In my formula I tried with "tr...
Tips and Tricks
  • LaurentZ's avatar
    LaurentZ
    6 years ago

    Thank you edhans for your answer.

    So there is no native function in powerquery to valuate those kind of error... that's sad.

    Thanks for the article, I'll give a try later.

    By waiting I keep my methodology tant consits in checking if Numerator & denominator are not 0 before doing a division... not the smartest but at least it works.

Diogo_Dalla's avatar
Diogo_Dalla
Frequent Visitor
2 years ago

I achieved the result by using

 

if (A / B) = Number.NegativeInfinity

then 0

else if (A  / B) = Number.PositiveInfinity

then 0

else (A  B)