Count distinct clients each from from January...

[paulb1]

 If I have a total of 400 unique clients in January and it grows to 800 unique clients in October, how can I get a count of how many distinct clients were added for each month?

Ex.

Jan - 400

Feb - 43

Mar - 61

Apr - 31

May - 55

Jun - 49

Jul - 65

Aug - 33

Sep - 30

Oct - 33

800 total

My data set starts in January and I will add to it at the end of each month.    It is a list of services and dates, so a client can have multiple services in different months.

Thank you!!

[MarqueeCrew · Accepted solution]

Step 1: SORT data by ID, Date ( note date and not month)
Step 2: UNIQUE data by ID.
Step 3: Take Unique values through SUMMARIZE by MONTH

that’s the answer.

Cheers,
Mark

[paulb1]

Genius!  Not sure how I deciphered your answer (being a relative noob), but I did and it worked!

Thank you so much.

[MarqueeCrew]

Congrats 🎊 your ready to start some weekly challenges and really start to accelerate your abilities.

Cheers,

Mark