Excel - Get & Transform (Power Query) - transforming "infinity" coming from division by zero

[datasetleo]

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! 🙂

[Zubair_Muhammad · Accepted solution]

@datasetleo 

Hi

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

[datasetleo]

Thanks!!!