Hello:
I am relatively new to modeling in Power BI.
I am working with a dataset that is essentially a one-stop dump for everything. Refer below:
| Qtr | Fiscal Year | Country | Category | Sub-Category | Sales |
| 1 | 2022 | A | Low | | 100 |
| 2 | 2022 | B | Med | a | 250 |
| 3 | 2023 | B | Med | b | 600 |
| 4 | 2022 | C | High | | 100 |
| 2 | 2023 | B | High | | 50 |
| 3 | 2022 | C | Low | | 275 |
| 4 | 2022 | A | Low | | 210 |
Quarterly sales data for each fiscal year is being captured for 3 countries across 3 categories (only one of which has sub-categories) and is being used for dashboards. That is all that is being captured and this is expected to continue well into the future. Is this the best way to go about it? Should I be looking into breaking this table down into smaller tables? I am concerned that with more data being added over the coming years, performance is going to suffer. An suggestions/guidance would be much appreciated. Thanks in advance.
