Forum Discussion
Finding New/Existing Customers
Hi,
Try this calculated column formula
=if(CALCULATE(COUNTROWS(Data),FILTER(Data,Data[Account Code]=EARLIER(Data[Account Code])&&Data[Created Date]<EARLIER(Data[Created Date])))=0,"New","Existing")
Hope this helps.
Hi,
That will happen if the date is the Account code appears more than once on the same date. If you want the second instance on the same day to be marked Existing, then there should a column of Time as well. Share the dataset where you also have a Time column.
Hey Matt,
Thanks.
I have gone through this article before, but couldn't make it work.
Also it is mandatory for me to create a column as per the requirement I'm given.
Anyway I could do that?
I don’t have my pc so I can’t look at the file. Assuming there is a 1 to many relationship between customers and sales, and assuming the sales table has one row per shopping event, and assuming that your definition of a new customer is someone’s that has only 1 record in the sales table (Ie a customer that purchased once in 2002 is still “new”) and assuming that every customer in the sales table has at least 1 one transaction, then something like this should work
=if(calculate(countrows(sales))=1,”New”,”Existing”)
MattAllington Creative, but i need to maitain the first entry as new and the subsequent as existing.
Anyways Thanks!