Forum Discussion
Matrix group column two tables
Hi Community
i want to merge some data from two tables in a matrix view.
the "Jahr" column the year column is present in both tables.
andy ideas?
HI PeterK,
AFAIK, the current power bi data model only allows one major relationship activated. (the others will be turned into inactive to prevent the conflict of analysis and aggregations)
I'd like to suggest you take a look at the following link to use star schema with dimension tables to link different tables:
Understand star schema and the importance for Power BI - Power BI | Microsoft Docs
Regards,
Xiaoxin Sheng
2 Replies
HI PeterK,
AFAIK, the current power bi data model only allows one major relationship activated. (the others will be turned into inactive to prevent the conflict of analysis and aggregations)
I'd like to suggest you take a look at the following link to use star schema with dimension tables to link different tables:
Understand star schema and the importance for Power BI - Power BI | Microsoft Docs
Regards,
Xiaoxin Sheng
Hi,
Assuming you have a Date column in your Data table, create a Calendar Table with calculated column formulas for Year, Month name and Month column. Sort the Month name column by the Month number. To your visual, drag the Year column. Create a relationship from the Date column of each table to the Date column of your Calendar Table.
Does this help?
