Forum Discussion

morab's avatar
morab
Icon for Advocate I rankAdvocate I
7 years ago
Solved

Repeat Customer

Hi, Good Day!   Following is the data table: OrderDate Distributor Code OutletCode SRName Category SKUCode OrderKG SalesKG 9/1/2019 14413 100033897 Shipon DDP 403 0.48 0.48 ...
Need Help
morab's avatar
morab
Icon for Advocate I rankAdvocate I
7 years ago

Hi lc_finance 

 

Thanks a lot for your kind cooperation. :smileyhappy:

You are Superb!!! :heart::heart:

Its working for me.:smileyhappy:

 

I would like to request, can you please help me to have slicer option (of followings columns) for "Repeat Customer Different Days" also. Currently which is working only for "Repeat Customer". 

- by "Category" (already have the solution in your shared measures)

- by "SRName"

- by "SKUCode"

- by "Route"

 

Here is the link for the Excel file: https://www.dropbox.com/s/lj12jexql84iqmq/order_sales.xlsx?dl=0

 

Here is the Screenshot (MS.EXCEL) :


 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Looking forward to your kind cooperation :)

need help 

lc_finance's avatar
lc_finance
Icon for Solution Sage rankSolution Sage
7 years ago

Here is the new formula, I took the time to simplify it:

 

RepeatCustomerDifferentDays New = 


SUMX(VALUES('Datatable'[OutletCode]),
    VAR dates =  CALCULATETABLE(VALUES('Datatable'[OrderDate]))
    RETURN IF(COUNTX(dates, [OrderDate])>1,1,0)

)
  • morab's avatar
    morab
    Icon for Advocate I rankAdvocate I
    7 years ago

    Hi lc_finance