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? Th...
- 7 years ago
Anonymous
Hi
if [%YoY]= Number.PositiveInfinity then ___ else -----
Zubair_Muhammad
7 years agoCommunity Champion
Anonymous
Hi
if [%YoY]= Number.PositiveInfinity then ___ else -----
- Anonymous7 years agoNot applicable
Thanks!!!