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,
Thank you so much for the suggestion. I managed to adjust the database, in order to be in a more clear format. Now it looks like this:
I will post also a sample from the second table when I will have the new format.
In the report I have to calculate some changes, like in the below example:
And when I will receive the table containing product data I would like to be able to drill down in the report matrix like this Subcategory--> Supplier --> Brand --> Product. This is why I think I have to connect the tables.