many to many relation ship problem

Hello herosoftware ,

Create dim tables that are both to these two tables you have then view data upon these dimensions.

check the concept of star schema data Modeling https://learn.microsoft.com/en-us/power-bi/guidance/star-schema

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡