Forum Discussion

LaurenceSD's avatar
LaurenceSD
Icon for Advocate II rankAdvocate II
5 years ago
Solved

Running total - stop at today

Hi,   I've managed to create a running/cumulative total for my bookings, however, I'm trying but failing to find a way of stopping this year's line carrying on past today's date.   My Dax formula...
Need Help
  • LaurenceSD's avatar
    LaurenceSD
    5 years ago

    a slicer of dumb luck led me to the correct formula, when playing about with some other ideas I accidentally left out the .date from my date table and voila it worked - I'm guessing something to do with the way time intelligence works (i'd not marked my date table as a table, as I wanted to be able to use the predefined heirachy)

     

    So this

    CALCULATE(BOOKINGS[Bookings],DATESYTD('DATESBKGS&ENQS'[Dates-Bkg&Enq].[Date]))

    becomes

    CALCULATE(BOOKINGS[Bookings],DATESYTD('DATESBKGS&ENQS'[Dates-Bkg&Enq])

    & it works strangely (or not so strangely I'm sure to some!)

  • LaurenceSD's avatar
    LaurenceSD
    Icon for Advocate II rankAdvocate II
    5 years ago

    thanks Greg_Deckler I've not yet quite found the formula from your list that does what I'm looking for, but I'm sure it must be in there, I'll keep on persevering, thanks for your help