New and Repeat Customers

[Jameswh91]

Hi, I need to sort our customers into new, returning, multiple purchases in current financial year who bought in the previous year and new customers with multiple purchases in financial year. The dax calculation needs to be dynamic so that i can use it to determine sales amount and orders of product by the customers. 

Financial year runs from May-April, so new customers who've acquired between these dates would need to be defined as a new customer.

Any help with this would be greatly appreciated!

[Idrissshatila]

Hello,

Check this article by SQLBI it may help you with your situation.

https://www.daxpatterns.com/new-and-returning-customers/

If I answered your question, please mark my post as solution, Appreciate your Kudos!