New Customers with multiple purchasers in a set time period e.g a year, numbers of repeat purchasers

[Jameswh91]

Hi, i'm looking to create a calculation that shows over the course of the financial year how many customers we have who have made repeat purchases. This would be split into, new customers in the financial year making multiple purchases and retuning customers who make multiple purchases. What would be perfect is if could filter the products based on the numbers of these customers to see how many orders included the products and how much money was spent.

For the customers, my desired layout would look like the below:

Date                  New Customers                 New Customers (multiple)    Returning Customer         Returning Customer (multiple)

2021                    1620                                        214                                                        100                           20

Any help would be very much appreciated!

[ImkeF]

Hi @Jameswh91 ,
this is a perfect use case for the new window functions: Introducing DAX Window Functions (Part 1) – pbidax (wordpress.com)
If you cannot make it work after reading that article, please paste proper sample data and description of the desired result: 

help how to get your questions answered quickly - Microsoft Power BI Community