Year on Year difference without date table

Hi LUCASM ,
To calculate the Year on Year (YoY) Difference and YoY Difference % without a date table, you can use DAX measures:
Create a measure for the previous year’s value:

Value LY = 
VAR Prev_Year = MAX(Forecast[Year]) - 1
RETURN
CALCULATE(
    [Total Value],
    FILTER(
        ALL(Forecast),
        Forecast[Year] = Prev_Year
    )
)

Create a measure for the YoY Difference:

YoY Difference = 
[Total Value] - [Value LY]

Create a measure for the YoY Difference %:

YoY Difference % = 
DIVIDE([YoY Difference], [Value LY], 0)

This setup should give you the desired output with the values and their differences year over year.

Thank you!