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 1574 times


Thanks for your help

Re: Total Sales LY ID from Supercharge Excel

Posted: Wed Nov 14, 2018 8:23 pm
by MattAllington
Mmm, sorry I missed this earlier. Did you sort it out? It should be <=MAX()