Forum Discussion
joshua1990
Post Prodigy
Post ProdigyRunning total until today
Hi all!
I have a simple line bar chart that displays the latest information (Sum Value) vs the Budget.
The line represents the budget accumulated per day for the selected month.
The bar represe...
joshua1990Post Prodigy
Post ProdigyGreg_Deckler : Thanks a lot for sharing this alternative. But please note, my question is different > How can I cut a running total chart for the whole month (distributed per day) but with just values for the past?
Using your approach I still get a values for tomorrow etc.
Greg_Deckler
Community Champion
Community Championjoshua1990 Handling tomorrow values is pretty easy, you just need an IF statement.
// Your code that results in a running total in a VAR named __RT
VAR __Result = IF(MAX('Date'[Date]) > TODAY(),BLANK(),__RT)
RETURN
__Result