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.
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
[Total Sales],
ALL ( 'Calendar' ),
>= MIN ( 'Calendar'[ID] ) - 365
&& 'Calendar'[ID]
>= MAX ( 'Calendar'[ID] ) - 365
but my result is not same show on your book,[img]
my result.jpg
my result
my result.jpg (51.25 KiB) Viewed 1818 times

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

Posts: 1050
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