Forum Discussion

Jameswh91's avatar
Jameswh91
Helper III
3 years ago

New and Repeat Customers

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!