sameperiodlastyear doesn't work :(

[LoryMenCR]

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 

[aduguid]

Try this measure 

Revenues PY =
CALCULATE(
    [Revenues],
    SAMEPERIODLASTYEAR(ALL(CalendarTable[Date]))
)

[Idrissshatila · Accepted solution]

Hello @LoryMenCR ,

check this https://youtu.be/bAOs5LTP0I0?si=eZTMwM50gci-Y6Z3