Forum Discussion
Solved
sameperiodlastyear doesn't work :(
Dear All,
I have the following measure to define my Revenues PY
Revenues PY =
CALCULATE (
[Revenues], SAMEPERIODLASTYEAR(CalendarTable[Date]))
It works fine except for when I filter for current year and month (2024/08). In this case it returns the comparison between 2024/08 and 2023/12! But i want it to compare 2024/08 with 2023/08.
Any idea?
Than you a lot
2 Replies
Try this measure
Revenues PY = CALCULATE( [Revenues], SAMEPERIODLASTYEAR(ALL(CalendarTable[Date])) )
