Formatting needed to get rid of YoY % - inf when PY is zero

[PBI-Curious]

Hello PBI Community Good Day!

What can I add to my switch statement below to get rid of inf in the YoY % column when PY (GL) is zero?

Much appreciate your time.

Thank you

[PBI-Curious]

Tamerj1

That did the trick. 

Much appreciate your help!

Thank you

[PBI-Curious]

Hello Tamerj1

I'm gettting an error when using DIVIDE.

Much appreicate your help!

[tamerj1]

hi @PBI-Curious 

Replace the "/" sign with the DIVIDE function 

[tamerj1 · Accepted solution]

@PBI-Curious 

DIVIDE ( [QTD CY] - [QTD PY] ), [QTD PY]] )