Compare previous and new sales for product

[Gonza]

Hi,

Building a report and slicing by year and month.

I want to compare the sales with earlier sales consider the product , so I try with

• RevenueLastYTDBU = CALCULATE(sum(Sales[REAL_ValorNeto]); SAMEPERIODLASTYEAR(Sales[FechaPivot]);All(Sales))

and 

• RevenueLastYTD = CALCULATE(sum(Sales[REAL_ValorNeto]); SAMEPERIODLASTYEAR(Sales[FechaPivot]);AllExcept(Sales;Sales[FechaPivot]))

However, I don´t get returned sales for year, month and product.

Are there manner ways to compare sales in previous periods for each product? E.g. the amount for product: "machines" in 29/1/2017 must be zero.

[dearwatson · Accepted solution]

I think you just need to remove the ALL(Sales) at the end to get the desired result.

with ALL you are removing the Product filter which you want to keep in place.

I got the below result with this measure:

Total Sales = SUM(Data[Value])

Sales Last Year = CALCULATE([Total Sales],SAMEPERIODLASTYEAR(Data[Date]))

[Gonza]

dearwatson, thank you so much for your help. 
But, something is missing because I can not get the result despite eliminating ALL(Sales).
The error is the same.

Please send me your .pbix file
is That possible?

[dearwatson]

Sure no problem

not sure how to attach but here's a onedrive link.

Sales.pbix

[Gonza]

Excellent !! Thank you.