March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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?
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,
Can you share a sample .pbix (uploaded to dropbox or sharepoint)?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
124 | |
87 | |
85 | |
70 | |
51 |
User | Count |
---|---|
205 | |
153 | |
97 | |
79 | |
69 |