Write values in column from last year

Hi dirkkoch 

Use EDATE([date column], -12) function to get the same date in last year. This would not have that problem. For leap years, it will get last year's Feb 28th's value for this leap year's Feb 29th. 

calculatedColumn =
MAXX (
    FILTER (
        t1,
        t1[Route] = EARLIER ( t1[Route] )
            && t1[Datum Auswertung] = EDATE ( EARLIER ( t1[Datum Auswertung] ), -12 )
    ),
    t1[Anzahl Lieferungen]
)

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.