Forum Discussion
Retail data - Last year
I am trying to build a report that shows current sales, budget, target and prior year sales. The data pulled in via SQL has historical sales data from current to 2014. As we are dealing with retail...
Hi vwiles84 ,
Sorry for our late reply, Could you please try to use the following measure?
Sales Of Same Week Day Last Year =
CALCULATE (
SUM ( 'Table'[Value] ),
FILTER (
ALL ( 'Table'[Date] ),
'Table'[Date]
IN SELECTCOLUMNS ( DISTINCT ( 'Calendar'[Date] ), "D", [Date] - 369 )
)
)
Best regards,
The measure is just pulling in the complete total of sales for each location vs. the sales on the day. So if I filter on 2/2/20, the actual sales column is calculating the sales for just that day. but the Prior year column with the caluculation you suggested is totaling the entire sales entries for each location.