New Customers vs Existing Customers

[BORUCH]

Hi all

I have my invoice history sales table in power pivot examples of fields are customer number , customer name , invoice number invoice date, item number ,description ,price etc...

I would like a column measure to identify new customers vs exiting customers based on the invoice date filter so if i would filter from October 2021 to October 2022 and i select exiting customers in my slicer it should only show me customers that had sales prior to October 2021

Thanks

 

[BORUCH]

anyone can please help out with this question please

 

[BORUCH]

any suggestions on my question ?