Forum Discussion
Incremental distinct customer count
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 |
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/
1 Reply
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/