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
LaurenceSD's avatar
LaurenceSD
Icon for Advocate II rankAdvocate II
2 years ago

Bookings This Year is simply a countrows formula, labeled as This Year for ease (I then have LY, LY-1, LY-2, etc coming off with SAMEPERIODLASTYEAR) but nothing clever going on with it.

 

I'll check out the video looks useful, thanks