Running Total Stop on Today

[Jcramb]

Im trying to make a running total that stops calculating on today.  I cant figure out how to modify my Dax to make it work.  Below is my running total.  How to modify to make it work?  I the result should be that the black line stops when brown bars stop, which is also "today"

Actual Quantity Cumulative =
CALCULATE(
SUM('Daily Richardson Quantity Tracking'[Actual Quantity]),
FILTER(
ALLSELECTED('Richardson Weekly Targets Power BI'[Date Weekly]),
ISONORAFTER('Richardson Weekly Targets Power BI'[Date Weekly], MAX('Richardson Weekly Targets Power BI'[Date Weekly]), DESC)
)
)

[PaulDBrown · Accepted solution]

You can try using a new measure with an IF function:
IF ( MAX( datetable [date] ) > TODAY(), BLANK(), [Your cumulative measure] )