Page 1 of 1

Total Sales LY ID from Supercharge Excel

Posted: Mon Jul 30, 2018 2:12 am
by 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.jpg
my result
my result.jpg (51.25 KiB) Viewed 1223 times


Thanks for your help