Monthly and Weekly Distinct Count

[rickster97]

Hi,

I want to calculate unique customers / week, such that, when I add them up I get the same number of unique customers / month.

I have the following PowerPivot table:

Total customers (took distinct count of customer ID) per month were:
1) January (ene): 1
2) February (feb): 28
3) March (mar): 219
4) April (abr): 416

I actually made a Week Column (Columna 1) in the original database but it still doesn't work the way I need it to (red numbers are the sum of all weeks for a given month):

I understand that I get a total of 30 for February because there were 30 purchases made by 28 clients.
What I would like to be able to get sort of "automatically" is the following:

Total Unique Clients February:
Week 1: 5
Week 2: 9
Week 3: 6
Week 4: 8
Total: 28

I actually figured a manual 4-step approach to get weekly results but it is not practical given the amount of data I have to analyze.
Contrary to most videos I don't want to delete the total or make the total 30 (February). I want the total to remain 28 (February), so that each week only includes customers that made their first purchase of the month during that week.

Can anyone help please?
Thanks in advance.

 

[Fluff]

Duplicate to: Monthly and Weekly Distinct Count

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.