Forum Discussion
Relationship
Hi Atchaya-Prabhu ,
I suggest you to create Dim tables like a DimBannerName table to create a relationship between it and Table1 / Table 2.
DimBannerName and Table 1 (one to many)
DimBannerName and Table 2 (one to many)
You may refer to below offical blog to learn more details about many to many relationship in Power BI.
For reference:
Many-to-many relationship guidance - Power BI | Microsoft Learn
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super UserHello Atchaya-Prabhu ,
You should build this model as a start shcema model in order to build one to many relationship.
learn more on how to build a star shcema model using this link 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 👍