Measure where customer bought same product this year (period) and last year (period)

[caseywhite]

Hello All,

We have a dataset with transactional data (Invoice #, Item Number, Customer Number, QTY, Sale Value, Cost) that we need to analyze for pricing.  We need to display a list of customers where they bought the same product this year (ytd) and last year (ytd).  

I have a measure for calculating Total Sales LY, Total Cost LY, etc... but I'm struggling with how to create a measure for 'Total Sales Last Year - Same Product' and 'Total Sales this Year - Same Product'

This is my current measure for total sales.  This gives me everything though.

Total Sales LY = CALCULATE([Total Sales],SAMEPERIODLASTYEAR(Dates[Date]))

Can anyone help?

[v-sihou-msft]

@caseywhite

Do you need to analyze your data on each Product Level? Or you want to get the customers bought same product for both years, no matter what product? 

Regards,

[caseywhite]

We would eventually need to see both.

1: Customers who bought the same product this year, and last year (same period) so we can analyze the price increase/decrease across these customers.

2: Products that were bought this year, and last year (same period) so we can analyze the price increase/decrease across these products.

[GabrielSantos]

Can you share a sample .pbix (uploaded to dropbox or sharepoint)?