Forum Discussion

censoft17's avatar
censoft17
Frequent Visitor
8 years ago

new customer list

Hi,

I want to display a list of new customers within a particular date range.

For eg new customers list for July 2017

 

Output Template:

CustomerID || OrderID || FullName || EmailID || OrderDate || ProductName

 

Please provide a valuable solution.

1 Reply

  • SruthiBAS's avatar
    SruthiBAS
    Regular Visitor
    8 years ago

    Hi,

     

     

     

    Assuming already existing customers have the same customer id till date. Take a copy of the table and filter the dates for the required month (July as of your data). Compare the customer ids of the two tables, the new customer ids will not match with the customer ids of the earlier months.

     

    Tablenew=FILTER(Tableold,DATESBETWEEN(Tableold[Datecolumn].[Date],Startdate,Enddate)

     

    Use an IF Expression to compare the customer id coulumns of the two tables.

    This boolean output can be recorded in a separate column and filtered.

    This filtered list will have the lis of new customers.