Forum Discussion

VModani's avatar
VModani
Frequent Visitor
4 years ago
Solved

How to identify new customers

I have a sales table with reoccuring customers. I need to identify new customers over the entire table, not restricted by a time frame. The Distinctcount(Customers) function counts distinct customer...
Need Help
Tutorial Requests
  • David-Ganor's avatar
    David-Ganor
    4 years ago

    Hi VModani ,

    Generally, you can point out when was the first time a customer is shown on the table, and count thise rows or customers by that.

    Please create a Calculated column as follows:

    Customer first appearance=

    Var this_row_customer=Table[Customer Name]

    Var this_row_sale_date=Table[Sale Date]

    Var first_appreance=Calculate (MAX(Table [Sale Date])

    FILTER(Table, Table[Customer Name]=this_row_customer]))

    Return

    IF(this_row_sale_date=first_appreance, Table[Customer Name],"")

     

    Then - on the visual - count the Table[Customer first appearance] by Sale Date.

    Hope it helps

    David

     

ashu131813's avatar
ashu131813
New Member
3 years ago

I have aquery regarding the same.I need New Customers that are added in my website in a year.For that I used this DAX Query -

New customers = 
VAR currentCustomers = VALUES('Sales table'[customer])
VAR currentDate = MIN('Sales table'[date])

VAR pastCustomers = CALCULATETABLE(VALUES('Sales table'[customer]), 
    ALL('Sales table'[date].[Month],'Sales table'[date].[MonthNo],'Sales table'[date].[Year])
    , 'Sales table'[date]<currentDate)

VAR newCustomers = EXCEPT(currentCustomers,pastCustomers)
RETURN COUNTROWS(newCustomers)

 

 

But I want to filter only those Customers who came from certain region ie I want to add Filter in the above query like
FILTER(Geo_Data, Geo_Data[Region] IN {
"East",
"North-East",
"North"
}
)

 

 

Is there any way to do this thing?