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

    Anonymous , is this issue resolved