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 s...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    7 years ago
    You can try using a new measure with an IF function:
    IF ( MAX( datetable [date] ) > TODAY(), BLANK(), [Your cumulative measure] )
PaulDBrown's avatar
PaulDBrown
Community Champion
7 years ago
You can try using a new measure with an IF function:
IF ( MAX( datetable [date] ) > TODAY(), BLANK(), [Your cumulative measure] )