Forum Discussion
Anonymous
7 years agoNot applicable
Excel - Get & Transform (Power Query) - transforming "infinity" coming from division by zero
Hi, All
I am calculating a %YoY, and I am getting some "infinity". How can I use something in "custom columns" to change infinity instances to say... "0" or just to have control over that?
Thanks! :)
Anonymous
Hi
if [%YoY]= Number.PositiveInfinity then ___ else -----
2 Replies
- Zubair_MuhammadCommunity Champion
Anonymous
Hi
if [%YoY]= Number.PositiveInfinity then ___ else -----
- AnonymousNot applicable
Thanks!!!