Customer Churn - Find Lost, New & Returning Customers with Power BI

preview_player
Показать описание
Customer Cohort Analysis clearly explained using DAX formulas in Power BI.

Please find the DAX code in the link below:

#powerbi #powerquery #dataanalytics #datamodeling
Рекомендации по теме
Комментарии
Автор

Hi, how to show sum of lost, new and returning customers at bottom line? so that i can do divide function to get percentage from each measure.

ThirayutPabhawinsakul
Автор

Hi Sir,
The same but i have a slicers of Year and Month name from calendar table. If i need to show new, repeated values from sales table also lost customers value of previous year month based on slicers selection. What would be the easyway to do this? Same visual table. Against customer key/name

WaqasGulll
Автор

@Data Analytics Central
How did you create dimdate table could you share these dimdate dax functions

mokshi
Автор

The data with huge customer list is very difficult to analyze here. Management wants count of lost customer with total revenue lost and if they want to drill down then they can find top customer name lose. This arguments and report is good but i wish if i can find something more high level easy and not lost in long list of customer.

ShoaibAhmed-bcsb