Forum Discussion
Monthly product performance since launch date
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
Anonymous , Dynamic segmentation is needed
https://www.daxpatterns.com/dynamic-segmentation/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization
9 Replies
- Greg_Deckler
Community Champion
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.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
- 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.
- amitchandak
Super User
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=tuk1CrigTSICan you share sample data and sample output in table format? Need to create a pbix to check.
