Forum Discussion
Builiding model relationships
Hello, I have the following two tables from a database and I am struggling to create a Power BI model: The data is splited like this: Table 1: Time period --> Month and Year Main cat...
Hi Anonymous,
Your scenario seems not suitable to use the relationship to link tables, there are too many relationships fields. For power bi model design, normally use one major relationship to analysis across different tables.
I'd like to suggest you extract similar fields and union two table records. (you can add a new field to mark which table these records from) Then you can simply write measure formulas to compare between two table records.
Relationships in analysis services tabular models
Union two tables with different columns and sum the same register
Regards,
Xiaoxin Sheng