Incremental distinct customer count

[Anonymous]

I am trying to create an incremental customer curve showing number of unique customers from begining to end of month by day. As an example, if 100 people ordered in Jan 1 and 100 people placed orders in Jan 2 but 22 of the customers in Jan 2 were new  , the total unique customers would be 122 .  I need to build this by date or by product (how many people ordered product A, Product A & Product B, etc...) 

I appreciate any pointers on what approach might work. Thanks in advance 

Date	# of Customers	Distinct Customer Count (Jan 1 forward)
1/1/2022	100	100
1/2/2022	100	122
1/3/2022	100	129
1/4/2022	100	133
1/5/2022	100	145
1/6/2022	100	177
1/7/2022	100	199
1/8/2022	100	211
1/9/2022	100	233
1/10/2022	100	255
1/11/2022	100	288
1/12/2022	100	299

[ebeery · Accepted solution]

@Anonymous if you haven't already, I would recommend starting by referring to the "New and Returning Customers" Dax Patterns.  It seems to me that some of the New customers patterns contained there may be adapted and/or combined to solve your use case.

https://www.daxpatterns.com/new-and-returning-customers/