Issue Cumulative Sales based on Week

Cumulative Revenues LY = 
Var MaxDate = MAX('Dim Calender Sales Invoice'[Date])
Var LastYear = YEAR(TODAY())-1

Return
Calculate([Total Revenues];
ALL('Dim Calender Sales Invoice');
'Dim Calender Sales Invoice'[Year] = LastYear;
'Dim Calender Sales Invoice'[Date] <= MaxDate 
)

 
Replace [Total Revenues LY] with [Total Revenues] in the measure above. 

I'm acutally not sure what is causing this behaviour, it's really strange. For some reason the 

'Dim Calender Sales Invoice'[Year] = LastYear;

 Filter isn't doing what it should. You should not have 2019 and 2020 appear in the matrix. 

Hello tex628,

unfortunalty the issue isnt solved yet. I also ried to rebuilt my Dim Calender table but still the issue is there.