Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
For running total you can simply use
Running total =
Calculate ( sum[ticket]), filter ( all(date), date[date]<= max(date[dat]))
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