Forum Discussion

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

remove future dates from sameperiod last year calc

Hi,   I'm struggling with this, despite trying numerous suggestions   These are my formulas so far   Bookings = DISTINCTCOUNT(BOOKINGS[BookId]) Bookings LY (Bk date) = CALCULATE(BOOKINGS[Bo...
Need Help
  • LaurenceSD's avatar
    LaurenceSD
    5 years ago

    so i believe i've found a solution, which, I stumbled upon by accident which was removing the .date

     

    So changing this

     

    Bookings LY (Bk date) = CALCULATE(BOOKINGS[Bookings],SAMEPERIODLASTYEAR('DATESBKGS&ENQS'[Dates-Bkg&Enq].[Date]))

     

    to 

     

    Bookings LY (Bk date) = CALCULATE(BOOKINGS[Bookings],SAMEPERIODLASTYEAR('DATESBKGS&ENQS'[Dates-Bkg&Enq]))

     

    Seem to work, I'm guessing it must have something to do with the time intelligence function, but thought i'd post for anyone else who may have a similar querey

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

so i believe i've found a solution, which, I stumbled upon by accident which was removing the .date

 

So changing this

 

Bookings LY (Bk date) = CALCULATE(BOOKINGS[Bookings],SAMEPERIODLASTYEAR('DATESBKGS&ENQS'[Dates-Bkg&Enq].[Date]))

 

to 

 

Bookings LY (Bk date) = CALCULATE(BOOKINGS[Bookings],SAMEPERIODLASTYEAR('DATESBKGS&ENQS'[Dates-Bkg&Enq]))

 

Seem to work, I'm guessing it must have something to do with the time intelligence function, but thought i'd post for anyone else who may have a similar querey