ROI on Years

Hi icerdeira ,

Accoring your infomation ,it main point the  average value is a measure ,not a column.

I try the following sample data:

It seems to me that you need to present the averages from the table for the current year, and the averages for [current year - 1 year], and then calculate the roi:

reaverage = var maxyearlast=CALCULATE(MAX('Table'[year]),FILTER(ALL('Table'),'Table'[year]<MAX('Table'[year])))     return CALCULATE(AVERAGE('Table'[value]),FILTER(ALL('Table'),'Table'[year]=maxyearlast))

roi = if('Table'[reaverage]=BLANK(),BLANK(),   DIVIDE('Table'[Average value],'Table'[reaverage])-1)

If there are any further questions, you can adjust my template data and present the results you want based on the template data.

Best Regards

Lucien