Forum Discussion
First non zero sale date
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 , Try like
Date New Customer =
CALCULATE ( MINX( Filter(SalesData, SalesData [Sales] >0 ) , SalesData[Pstg date] ),
ALLEXCEPT (SalesData , SalesData[Customer], CustomerMaster ))
2 Replies
- amitchandak
Super User
Anonymous , Try like
Date New Customer =
CALCULATE ( MINX( Filter(SalesData, SalesData [Sales] >0 ) , SalesData[Pstg date] ),
ALLEXCEPT (SalesData , SalesData[Customer], CustomerMaster ))