New Customer Acquisition

Sure, let's break down the code snippet you provided.

NewCustomers = 
    COUNTX(
        EXCEPT(AllCustomersPerMonth[Customers], PreviousCustomers[Customers]), 
        [Customers]
    )

DAX Functions Used:

There are two main DAX (Data Analysis Expressions) functions used:

1. COUNTX: A DAX statistical function that counts the number of rows of data in a column, where the values in each row are evaluated by their expression or measure.

2. EXCEPT: A DAX function that returns the rows of a table that are present in the first table parameter and not present in the second table parameter.

Explanation:

The overall aim of this code is to calculate the number of new customers, i.e., customers that are in 'AllCustomersPerMonth' but not in 'PreviousCustomers'.

1. EXCEPT(AllCustomersPerMonth[Customers], PreviousCustomers[Customers]):

   This part is using the EXCEPT function to find out the customers that are present in 'AllCustomersPerMonth' but not present in 'PreviousCustomers'. So basically, it's isolating the "new" customers.

2. COUNTX([...], [Customers]):

   The COUNTX function then counts the number of these new customers. It goes through the result of the EXCEPT function (a table of new customers) and counts the number of unique [Customers].

Conclusion:

The variable NewCustomers will thus hold the count of new customers that haven't made purchases in previous months but did in the current month. This type of calculation is valuable in business analyses for understanding customer growth and acquisition.

Also for further knowledge on DAX formulas and how to use them, Enterprise DNA Platform offers several in-depth courses which you may find beneficial. These courses provide a comprehensive understanding of how DAX functions work and how they can be applied to solve complex problems.