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!
