Forum Discussion
LaurentZ
Helper I
Helper IHow 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.
CidcleyBarbosa
Advocate IV
Advocate IVHi everyone,
One way to do this is with List.Max(your calculation, 0).
dufoq3
Community Champion
Community ChampionCidcleyBarbosa, don't forget curly brackets!
List.Max( { yourCalculation, 0 } )