Forum Discussion

Jcramb's avatar
Jcramb
Frequent Visitor
7 years ago
Solved

Running Total Stop on Today

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)
)
)

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

1 Reply

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    You can try using a new measure with an IF function:
    IF ( MAX( datetable [date] ) > TODAY(), BLANK(), [Your cumulative measure] )