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


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

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

Who is online

Users browsing this forum: No registered users and 1 guest