IF i use date table the same thing, an this will add a week53.
I have created a week table with a weekID but none of that seems to work (yyyyww), the closest i get was filtering week and result was correct but i had to filter without that correct values didn't appear.
The problem is that the MAX Week number is always going to be 52 (the last week of the year) so this is not the "current week" as such
The basic approach is first getting the current date then filter the calendar to show only the period we want relative to the current date.
Looking at your model we need something to depict the current date or week that can be sorted into order (ideally this would be a "week ending" date) otherwise you might need to create a new Year.Week surrogate key e.g 2019.01, 2019.02...2019.12 etc. then you use that for your MAX calc.
So then you can use the Year.Week to get the weeks you want.
Cantidad Last 4 weeks = VAR CurrentWeek = MAX(BP_SELL_out[Year.Week]) RETURN CALCULATE(SUM(BP_SELL_out[Cantidad]), BP_Sell_out[Year.Week]>=CurrentWeek-0.04))
(you can omit the && if there are no future dates in BP_Sell_out)
"The commonality between science and art is in trying to see profoundly - to develop strategies of seeing and showing." - Edward Tufte