Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
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?
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |