Forum Discussion
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...
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.
Hi everyone,
One way to do this is with List.Max(your calculation, 0).
CidcleyBarbosa, don't forget curly brackets!
List.Max( { yourCalculation, 0 } )
