How to get duplicate repeated/existing customers and new customers

[Anonymous]

Hi, We have requirement to identify how many new customers and repeated/existing(duplicate) customers.

User wants see them based on the date selection. The output they are example like below . 

CustNo	Date
8122746571	Jan-02-2008
8309664704	Jan-02-2008
7207295883	Jan-02-2008
7207295883	Jan-03-2008
7569650119	Jan-03-2008
8978806748	Jan-03-2008
8122746571	Jan-04-2008
8309664704	Jan-04-2008
7207295883	Jan-04-2008

Suppose, if user select 4th of Jan 2008, there are 3 customers vistited. Since,they also visited on 2nd & 3rd of Jan.

Hence, they want to consider them as existing customers.

2nd of Jan

8122746571

8309664704

3rd of Jan

7207295883

But, if the select 3rd of Jan to 4th of Jan.

There are there 6 customers 3 out of 6 customers are visited on 2nd of Jan. Hence, they want consider them 3 are existing customers and other 3 customers are new customers.

Please help me providing solution in POWER BI Desktop. Its bit urgent, i have been reading lots of posts last one week onwards, but could not find correct solution/logic to full fill this

[Anonymous · Accepted solution]

Hi @Anonymous ,

For a single date, you can create the following measure. 

Measure = IF(CALCULATE(COUNT('Table'[CustNo]),FILTER(ALLEXCEPT('Table','Table'[CustNo]),[Date]<=SELECTEDVALUE('Table'[Date])))>1,1)

Then create the visuals as follows, put the measure into Filters and set show items when the value is 1.

For your second request, it seems a bit difficult to complete.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.