Sales at a specific point in time

[abeirne]

Hi all, I am working on a measure that calculates reservation charges from the current YTD compared to the YTD same day last year. I want to see amount booked as of this time last year. The time intelligience functions I have seen seem to lump values together. For example, I only want to compare 1/1/2021 through 7/21/2021 with 1/1/2022 through 7/21/2022.  I was thinking something like this but currently this measure is not working:

DATES BETWEEN1 =

CALCULATE(

    MeasureTableQ[Reservation Charges SUM],

    DATESBETWEEN(

        CalendarQ[Date],

        PREVIOUSYEAR(CalendarQ[Date]),

        MAX(CalendarQ[Date])

    )

)

Error Message:
MdxScript(Model) (97, 9) Calculation error in measure 'MeasureTableQ'[DATES BETWEEN1]: A table of multiple values was supplied where a single value was expected.

Would the dates in period function be of any help?
Any help would be greatly appreciated, thanks!

[WinterMist · Accepted solution]

@abeirne 

The following 3 measures can achieve this.

Hope this is helpful to you.

Regards,

Nathan