Forum Discussion
Monthly product performance since launch date
Anonymous , Dynamic segmentation is needed
https://www.daxpatterns.com/dynamic-segmentation/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization
Sorry i am going to try to elaborate better
I have Two table in my model, calendar date and sales
I am trying to create a table that will show all the product and then the sales the first month, second etc.. but then for all of the product on a normalised way ( For the month) as in the table below
the goal is to be able to quickly see which product had the best launch, is doing better, comparing product that have similarities
I hope this can help to understand why i am trying to do 🙂
Thank you in advance
Hi Anonymous ,
Create a martix table as below.
Best Regards,
Jay
Hi All,
thank you for all your reply. My main issue is that i don't know how to create a measure that recognize the month of launch as first month and count from there till the 12 month. Because each product can have a different launch month. Maybe with a calculated column that count from the product launch and on ?
cheers
ilhame
- amitchandak
Super User
Anonymous , when viewing data by product and table min date will month. Or the better is create a launch date as column
example
First Sales = minx(filter(Retail, Retail[Customer_id]=EARLIER(Retail[Customer_id])),Retail[Order_Date])- amitchandak
Anonymous , is this issue resolved