Forum Discussion
Running Total - Resets with Date Filter
Hi, I've got a formula for calculating a running total which is this Bookings This Year Running Total = if(max(Dates[Date])<=today(), CALCULATE( [Bookings This Year], FILTER( ...
hello LaurenceSD
modification to your code :
Bookings This Year Running Total =
var min_date = calculate(min(dates[date]), allselected(dates[date]))
var max_date = max(dates[date])
if(max(Dates[Date])<=today(),
CALCULATE(
[Bookings This Year],
all(dates[date]) ,
dates[date] <=max_date ,
dates[date] > = min_date
)
)
),BLANK())
let me know if you need any other help
If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. Dont forget to hit that thumbs up button 🫡👍