First non zero sale date

[Anonymous]

Hi,

I am trying to get the first date of sale of a customer - where the sales value is more than zero.

I am currently using the following formula:

Date New Customer =

CALCULATE ( MIN ( SalesData[Pstg date] ), 

ALLEXCEPT (SalesData , SalesData[Customer], CustomerMaster ))

I picked this up from https://www.daxpatterns.com/new-and-returning-customers/

However, if we make a free of charge sample sale to a customer in May 22 - and then we sell to them properly in Jun 22, the formula above is counting them as a new customer in May - but ideally I'd want them to be classed as a new customer in June - when their sales value is above zero.

Any thoughts or advice?

Many thanks

[Anonymous]

Thanks amitchandak, that works perfectly 🙂

[amitchandak · Accepted solution]

@Anonymous , Try like

Date New Customer =
CALCULATE ( MINX( Filter(SalesData, SalesData [Sales] >0 ) , SalesData[Pstg date] ),
ALLEXCEPT (SalesData , SalesData[Customer], CustomerMaster ))