It would help if you could post a packaged workbook so everyone can see exactly what your data looks like.'
I've attached a workbook that shows a possible approach. Basically, I just used a distinct count of customer ID and then sliced by month. I'm not sure if that's exactly what you are looking for.
Customers by Month.twbx.zip 441.5 KB