Forum Discussion

LaurenceSD's avatar
LaurenceSD
Icon for Advocate II rankAdvocate II
2 years ago

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(   ...
Need Help
Daniel29195's avatar
Daniel29195
Icon for Community Champion rankCommunity Champion
2 years ago

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 🫡👍