I am working in this analysis where I need to identify new customers (buying for the first time, with no previous record) but for different periods of time.
[Fecha NV] - Date of the transaction
[Rut Cliente] - Customer ID
[NV] - Sales ID
I want to know how many are "new" customers or had their first [NV] for the current year.