Help with Cohort Analysis + Customer Retention Analysis

[Anonymous]

HI Guys , 

i am very new to Power BI ,so any help or pointers are greatly appreciated ,  i am given the task to create something like a Mix of Cohort Analysis & Customer Retention Analysis In power BI .so i have a table of CustomersName , Project IDs, TransactionDate,SalesAmount,

i want to create something like , when the Customers FIrst Appear in the system i.e. BornDate , and what SalesAmount was generated (if any) of these customers  over the years , What would be the best approach to Create this in Power BI  . 

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

Please refer to these:

https://community.powerbi.com/t5/Desktop/Cohort-Analysis-tutorial/m-p/727743 

https://janizajcbi.com/2018/06/12/customer-retention-churn-analysis/ 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , refer to my blog and video if they can help

#PowerBI Customer Retention Part 3: Period Of Stay – Cohort Analysis: https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-3-Period-Of-Stay-Cohort-Analysis/ba-p/1393410

Video: https://youtu.be/Q1vPWmfI25o