To add to what the others have said, please see if the following helps you. If I have understood your issue correctly, you do not need a relationship between the two transaction tables (Investment Table and Returns Table) to get your calculations. Please see the output, and relationship diagram below.
I apologize, if I have misunderstood your issue. PFA the pbix file also for your reference.