Forum Discussion
LoryMenCR
Helper I
Helper Isameperiodlastyear 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
- Idrissshatila
Super User
- aduguid
Memorable Member
Try this measure
Revenues PY = CALCULATE( [Revenues], SAMEPERIODLASTYEAR(ALL(CalendarTable[Date])) )
