Forum Discussion
Fact Table against Fact Table mer
Hi BishwaR
You can hold on Ctrl or Shift Key and select multiple matching columns at the same time to merge the tables. Make sure you select matching columns in the same order, so that the columns with the same order number will be matched.
For many to many relationships, you may refer to below articles.
Many-to-many relationships in Power BI Desktop - Power BI | Microsoft Docs
Many-to-many relationship guidance - Power BI | Microsoft Docs
Usually when I use a bridge table, I tend to use its columns in filters or slicers to filter other tables, or in Axis/Legend fields of a chart. Sometimes fact tables don't include a complete list of values. So I will include all values in a bridge table to avoid missing any item.
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
Hi BishwaR
You can hold on Ctrl or Shift Key and select multiple matching columns at the same time to merge the tables. Make sure you select matching columns in the same order, so that the columns with the same order number will be matched.
For many to many relationships, you may refer to below articles.
Many-to-many relationships in Power BI Desktop - Power BI | Microsoft Docs
Many-to-many relationship guidance - Power BI | Microsoft Docs
Usually when I use a bridge table, I tend to use its columns in filters or slicers to filter other tables, or in Axis/Legend fields of a chart. Sometimes fact tables don't include a complete list of values. So I will include all values in a bridge table to avoid missing any item.
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.