Help with a calculated table

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

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

Thank you so much for your interest in helping me!

Below is the link to the file. Please let me know if you are having issues accessing it.

Thanks in

https://hamaspikk-my.sharepoint.com/:f:/g/personal/lharfenes_hamaspikkings_org/EnRCip7LXj9Mvgv5Rnlf-8wBWIvuR5wdRa2v9vNIobX7fA?e=NpyJ5U