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...
Greg_Deckler
Community Champion
Community Champion
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
joshua1990 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