Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 meas...
Need Help
Tips and Tricks
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

     

    Create a martix table as below.

     

    Best Regards,

    Jay

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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's avatar
        amitchandak
        Icon for Super User rankSuper User
        6 years ago

        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])