Count New and Existing Contacts based on Case creation date

[monty74]

Hello

I am wanting to count the number of new and existing contacts based on the case (incident) creation date. For example I want to know how many case (incident) have been created to new contacts or exisiting contacts.  So if the contact associated with a case was created on a date before the case creation date then this would be an existing contact (not new). And if the contact was create on the same day as the case the this would be classed as a new contact.

I'm thinking there must be a formular to work this out, maybe on the record created on or modified on, just not sure where to start.

Any suggestions or help would be greatly appreiated.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523