new customer list

[censoft17]

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.

[SruthiBAS]

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.