When implementing churn analytics inside a Power BI, sometimes you can want to take the analysis even further. In this tutorial, I run through how you can not only work out how many customers are considered lost but also who are these particular lost customers.
This is really powerful stuff if you are looking to make sure your sales resources and marketing efforts are going to the right areas. Where you feel you can generate the best returns.
There's plenty of great practical applications to this technique. Good luck getting these ideas into your own models.
Sam
*****Video Details*****
0:18 - Introduction
2:25 - How To Create Attrition Analysis Report
4:10 - Using CALCULATETABLE
6:00 - Using The EXCEPT Function
6:26 - Showing Lost Revenue From Lost Customers
9:21 - Conclusion
***** Learning Power BI? *****
FREE COURSE - Ultimate Beginners Guide To Power BI - [ Ссылка ]
FREE COURSE - Ultimate Beginners Guide To DAX - [ Ссылка ]
FREE - 60 Page DAX Reference Guide Download - [ Ссылка ]
FREE - Power BI Resources - [ Ссылка ]
Enterprise DNA Membership - [ Ссылка ]
Enterprise DNA Online - [ Ссылка ]
Enterprise DNA Events - [ Ссылка ]
***** Related Links *****
Discover How Many Sales Can Be Attributed To New Customers - Advanced Power BI Insights
[ Ссылка ]
New vs Existing Customers - Advanced Analytics w/DAX
[ Ссылка ]
Counting Customers Over Time - DAX Example in Power BI
[ Ссылка ]
***** Related Course Modules *****
Advanced Analytics
[ Ссылка ]
Business Analytics
[ Ссылка ]
Unique Analytical Scenarios
[ Ссылка ]
***** Related Support Forums *****
Lost Customers Measure
[ Ссылка ]
Lost Customers Calculation
[ Ссылка ]
Lost/New Customers Each Year-Month
[ Ссылка ]
For more attrition analysis queries to review see here…..
[ Ссылка ]
![](https://s2.save4k.ru/pic/cfDyNPQIJtA/maxresdefault.jpg)