Forum Discussion
Jcramb
7 years agoFrequent Visitor
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
- PaulDBrownCommunity ChampionYou can try using a new measure with an IF function:
IF ( MAX( datetable [date] ) > TODAY(), BLANK(), [Your cumulative measure] )