Creating Year over Year sales but its giving infinite when clicked on particular year in trend chart

[Kartic21]

I am trying to create YoY% KPI but having issue when i click on partcular/one entering year on the chart it gives infnity.
sample data 

Formula :

Year over year perc =

var cy = max('Table'[Year])

var py = MAXX(ALL('Table'),'Table'[Year])-1

var cyenroll = CALCULATE([Totalenroll],FILTER('Table','Table'[Year]=cy))

var pyenroll = CALCULATE([Totalenroll],'Table','Table'[Year]=py)

return (cyenroll-pyenroll)/pyenroll

//(cyenroll-pyenroll)/pyenroll)


issue : when i click on any entering year in trend chart ,,its show infinty...it seems like it cant calculate pyenroll value



Can any please help on this..? Thanks

[Ashish_Mathur]

Hi,

You should ideally create a Date column first (can be Jan 1 of tht row's year) and then a calendar Table.  From thereon, the calcualtions will become simple.  To receive further help, share some data to work with?

[lbendlin]

instead of /  use DIVIDE  and provide an alternative result if the previous year's data is blank