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...
Greg_Deckler
Community Champion
Community ChampionDifficult to fully visualize your data in my head, perhaps sample data for the second table would help. Couple recommendations, I would unpivot your Period # this year columns.
Create a Date/Calendar table using CALENDAR or CALENDARAUTO. Create Brand, Category, Subcategory and Product tables using Table = DISTINCT('Table'[Column])
Relate all of your dimension columns to your fact tables in a star schema.