Who Are The Lost Customers - Advanced Analytics With Power BI & DAX

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 - http://portal.enterprisedna.co/p/ulti...
FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ulti...
FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-...
FREE - Power BI Resources - http://enterprisedna.co/power-bi-reso...
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Online - http://portal.enterprisedna.co/
Enterprise DNA Events - https://enterprisedna.co/enterprise-d...

**** Related Links ****
Discover How Many Sales Can Be Attributed To New Customers - Advanced Power BI Insights
https://blog.enterprisedna.co/2018/11...
New vs Existing Customers - Advanced Analytics w/DAX
https://blog.enterprisedna.co/2018/01...
Counting Customers Over Time - DAX Example in Power BI
https://blog.enterprisedna.co/2017/11...

**** Related Course Modules ****
Advanced Analytics
http://portal.enterprisedna.co/p/adva...
Business Analytics
http://portal.enterprisedna.co/p/busi...
Unique Analytical Scenarios
http://portal.enterprisedna.co/p/uniq...

**** Related Support Forums ****
Lost Customers Measure
https://forum.enterprisedna.co/t/lost...
Lost Customers Calculation
https://forum.enterprisedna.co/t/lost...
Lost/New Customers Each Year-Month
https://forum.enterprisedna.co/t/lost...
For more attrition analysis queries to review see here…..
https://forum.enterprisedna.co/search...