Forum Discussion
same customer in another domain
i have two seperate tables in data model one is for customer and another is for segment , same customer can exist in multiple business segment such as education , construction etc. is there a way to combine customer and segment tables into one table?
customer:
segment:
Hey powerbiexpert22 ,
of course there is a way, but as always it depends.
Looking at your tables I'm not able to identify a customer in your segment table. Next to that, creating tables is essential for creating a powerful semantic model. The tables that are created are called dimension and fact tables. I recommend reading these articles for a start if you are not familiar with dimensional modeling:- Design a semantic model in Power BI - Training | Microsoft Learn
- Define relationships in data models for data warehousing - Microsoft Fabric | Microsoft Learn
- Understand star schema and the importance for Power BI - Power BI | Microsoft Learn
From my experience it will not be possible to create a single table at least not a dimension table, because of the many-to-many relationship between the customers and segments tables.
For this reason most often it's not a single table but some kind of view that determines this table, like the combination of the dimension tables customers and segments in combination with a fact table sales. Then this view will provide insights for further analysis.
Hopefully, this provides some ideas of how to tackle your challenge.
Regards,
Tom
1 Reply
Hey powerbiexpert22 ,
of course there is a way, but as always it depends.
Looking at your tables I'm not able to identify a customer in your segment table. Next to that, creating tables is essential for creating a powerful semantic model. The tables that are created are called dimension and fact tables. I recommend reading these articles for a start if you are not familiar with dimensional modeling:- Design a semantic model in Power BI - Training | Microsoft Learn
- Define relationships in data models for data warehousing - Microsoft Fabric | Microsoft Learn
- Understand star schema and the importance for Power BI - Power BI | Microsoft Learn
From my experience it will not be possible to create a single table at least not a dimension table, because of the many-to-many relationship between the customers and segments tables.
For this reason most often it's not a single table but some kind of view that determines this table, like the combination of the dimension tables customers and segments in combination with a fact table sales. Then this view will provide insights for further analysis.
Hopefully, this provides some ideas of how to tackle your challenge.
Regards,
Tom