Total Sales LY ID from Supercharge Excel

[carlosam1409]

Hi! I wrote this
=CALCULATE (
[Total Sales],
FILTER (
ALL ( 'Calendar' ),
'Calendar'[ID]
>= MIN ( 'Calendar'[ID] ) - 365
&& 'Calendar'[ID]
>= MAX ( 'Calendar'[ID] ) - 365
)
)
but my result is not same show on your book,[img]

book.jpg

[/img]

my result

my result.jpg (51.25 KiB) Viewed 2675 times

Thanks for your help

[MattAllington]

Mmm, sorry I missed this earlier. Did you sort it out? It should be <=MAX()