Forum Discussion
How to continue running total calculation to a future date
Hello,
I am attempting to calculate a running total of tickets based on a 'datecreated' up to the time a customer is expected to use them ('expectedstart'). The formula in the screen shot works fine up through 8/1/2023, which is both the most recent cloud data refresh and the most recent 'datecreated'. The individual values continue to populate in the 'Tickets by Expected Start' column; however, the running total stops because the formula as it stands now is based upon 'datecreated' and not 'expectedstart'. Would appreciate advice on how to modify this formula (or even a different approach) to begin a new running total for each new 'expectedstart' date. For example, the first empty row in the right-hand column would read '66', the one below would read '137', etc. The end goal of this effort is to produce a visualization that depicts the build-up of tickets purchased over time by each 'datecreated' up until the final total at the 'expectedstart' date. Thanks in advance for your assistance. Jim
2 Replies
- AnonymousNot applicable
Hi jfollen ,
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
- Anil_kapkotiNew Member
For running total you can simply use
Running total =
Calculate ( sum[ticket]), filter ( all(date), date[date]<= max(date[dat]))