Total Sales LY ID from Supercharge Excel

This is a dedicated forum for people that have questions about the book Supercharge Power BI. In the event of errors in the book, the error information will be in this forum.
carlosam1409
Posts: 2
Joined: Mon Jul 30, 2018 2:02 am

Total Sales LY ID from Supercharge Excel

Postby carlosam1409 » Mon Jul 30, 2018 2:12 am

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


Thanks for your help
Attachments
book.jpg
from Supercharge Excel page 136
book.jpg (52.89 KiB) Viewed 1427 times

MattAllington
Posts: 1007
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Total Sales LY ID from Supercharge Excel

Postby MattAllington » Wed Nov 14, 2018 8:23 pm

Mmm, sorry I missed this earlier. Did you sort it out? It should be <=MAX()
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training


Return to “Help with the Book "Supercharge Power BI"”

Who is online

Users browsing this forum: No registered users and 1 guest