Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
  • Zubair_Muhammad's avatar
    7 years ago

    Anonymous 

     

    Hi

     

    if [%YoY]= Number.PositiveInfinity then ___ else -----