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?

 

Thanks! :)

 

 

 

2 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion

    Anonymous 

     

    Hi

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks!!!