Lost Customers DAX – Solution

[su_row][su_column size="1/2" center="no" class=""]
In this solution we explain how to calculate your number of new customers in DAX. A new customer is a customer which has transactions within a certain period and has no transactions before that period. We show you how you can solve this problem in DAX with the best performing code.[/su_column] [su_column size="1/2" center="no" class=""]

[video width="1920" height="1080" mp4="https://powerbi-solutions.com/wp-content/uploads/New-Customers-DAX-Intro.mp4"][/video]

[/su_column][/su_row]

[su_row][su_column size="1/2" center="no" class=""]
In this solution we explain how to calculate your number of returning customers in DAX. A returning customer is a customer which has a transaction within a certain period and has also one or more transactions before that period. We show you how you can solve this problem in DAX with the best performing code.[/su_column] [su_column size="1/2" center="no" class=""]

[video width="1920" height="1080" mp4="https://powerbi-solutions.com/wp-content/uploads/Returning-Customers-DAX-Intro.mp4"][/video]

[/su_column][/su_row]

[su_row][su_column size="1/2" center="no" class=""]
In this solution we explain how to calculate your number of active customers in DAX. An active customer is a customer which has transactions within a certain period. We show you how you can solve this problem in DAX with the best performing code.
[/su_column] [su_column size="1/2" center="no" class=""]

[video width="1920" height="1080" mp4="https://powerbi-solutions.com/wp-content/uploads/Active-Customers-DAX-Intro.mp4"][/video]

[/su_column][/su_row]

[su_row][su_column size="1/2" center="no" class=""]
In this solution we explain how to calculate the number of customers which are still creating sales for your company after the first transaction. So when you are investing in getting more customers you for sure are wondering how long that customers stay at your company and how many sales they generate for you. We also explain how you can analyze which products they buy.
[/su_column] [su_column size="1/2" center="no" class=""]

[video width="1920" height="1080" mp4="https://powerbi-solutions.com/wp-content/uploads/Customer-Retention-Intro-www.powerbi-solutions.com_.mp4"][/video]

[/su_column][/su_row]