How do you count Distinct Customers and group by first month seen?

Question

I have a series of customers over the course of the year that I need to group into two categories: New and Reoccurring.

The data roughly looks like this:

ID	Date Seen
1	August 1, 2022
2	August 3, 2022
2	July 1, 2022
2	June 1, 2022
3	July 1, 2022
3	August 1, 2022

New customers would show up on the month that we see their first record. Reoccurring would have more than 1 month logged with us.

How would I count these two groups?

So as an example above, I'd expect to see:

Month	Trial	Returning
August	1	2
July	1	1
June	1	0

Edit: Per request here's a link to a Data Studio report with mock data.

Answer 1

Added the solution to your dashboard. created a blend and used a calculated field to pivot the data

CASE WHEN Month (Table 1)=Month (Table 2) THEN 'TRIAL' ELSE 'RETURNING' END