New, Retentive and Returning Customers

Hi RoswithaR 
Thanks for reaching out to Fabric community.
Sorry for the late response.

You can achieve the sum of new, returning and retentive customers as follows-

1. Keep the order date
2. Add 3 measures for New, returning and retentive customers 
3. Remove Orders 

When you try to group-by Month as (YYY-MMM) the table will group-by Month-year and give the count for its respective month. This will not give the correct count as per Customer segregation.

Therefore, its possible to show the second table with Order date.

Attached Pbix for reference.

If the above information helps you, please give us a Kudos and marked the Accept as a solution.

Best Regards,
Community Support Team _ C Srikanth.