Forum Discussion
Tracking Customers Year Over Year
Hi,
You have to go to Modelling > New Table and then write that formula in the formula bar.
| MAIL # | Purchase Date | Product Type |
| 354 | 10/7/2016 | Day Pass |
| 214 | 10/8/2017 | Night Pass |
| 215 | 11/1/2017 | Day Pass |
| 789 | 11/1/2017 | Day Pass |
| 485 | 11/1/2017 | Night Pass |
| 784 | 2/6/2015 | Day Pass |
| 784 | 2/6/2015 | Day Pass |
| 784 | 2/6/2015 | Day Pass |
| 354 | 10/7/2017 | Day Pass |
| 215 | 10/9/2015 | Day Pass |
| 789 | 10/1/2014 | Night Pass |
| 354 | 10/7/2018 | Day Pass |
| 214 | 10/8/2015 | Night Pass |
Thank you for the responses. Above is the data that I would like to have analyzed...I am hoping to get results that look something like this...
| Year | Total Customers by Mail # | Number of Products Purchased | New Customers | Returning Customers |
| 2015 | 15 | 33 | 15 | 0 |
| 2016 | 20 | 30 | 16 | 4 |
| 2017 | 30 | 55 | 15 | 15 |
| 2018 | 100 | 350 | 75 | 25 |
I would also be interested in Identifying specific customers by Mail# that held a pass in one given year, did not return the following year, but still returned at a later date.
Hopefully that makes sense. Please let me know if you have any futher questions!
Thank you I think that should work, however I am getting an error with computing the date. I typed
Date = CALENDAR(MIN(Data[Purchase Date]),MAX(Data[Purchase Date]))
and I am getting an error of
"A table of multiple values was supplied where a single value was expected."
Any idea what is causing this error?Hi,
You have to go to Modelling > New Table and then write that formula in the formula bar.
Thank you so much for the help! That did it