Running total and max date

[PowerBITestingG]

I have a simple table with product week number and a running total measure:

Running Total = 
var maxdate = MAX(week)
return
CALCULATE(SUM(quantity),week<=maxdate)

Product	14	15	16
Macbook	20	40	60
PC	10	20

My problem is that I am not getting the running total for product PC week 16. I want it to display 20

There is no data for that week in the table which is just Product/Week/Quantity.

I tried linking it to a time table, but I still get the same issue

[Sahir_Maharaj]

Hello @PowerBITestingG,

Could you please try this:

Running Total = 
VAR MaxDate = MAX(week)
RETURN
CALCULATE(
    SUM(quantity),
    FILTER(
        ALL(week),
        week <= MaxDate
            && (ISBLANK(SUM(quantity)) || week > Max(week[week]))
    )
)

Let me know if you might need further assistance.