Monthly product performance since launch date

[Anonymous]

Hi, 

I have different product with different launch date and i want to analyse their performance by creating a sort of Cohort like the table below 

I don't know where to start with my measure, maybe someone already created this sort of table ? 

Would be very helpful ! 

Cheers 

[amitchandak]

@Anonymous ,

see if this can help.

https://finance-bi.com/power-bi-cohort-analysis/
http://funbiworld.com/2019-12-02-cohort-analysis/
https://www.youtube.com/watch?v=tuk1CrigTSI

Can you share sample data and sample output in table format?  Need to create a pbix to check.

[Greg_Deckler]

Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[Anonymous]

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 

[v-jayw-msft]

Hi @Anonymous ,

Create a martix table as below.

Best Regards,

Jay

[Anonymous]

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]

@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

[amitchandak · Accepted solution]

@Anonymous , Dynamic segmentation is needed

https://www.daxpatterns.com/dynamic-segmentation/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization

[Greg_Deckler]

@Anonymous - Seems like you could create a Matrix visualization with Item in Rows and Month Number in Columns. Then you should just be able to drop your "sales" column in as a Value and use the default SUM aggregation.

Let me know if that helps.