Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Help Structuring Table - cleaning up my mess

Hello,     I have been under alot of pressure to get dashboards/reports out and also upskill my self on Power BI.   Whlile there has been a very positive uptake of these, i need to do ALOT of cl...
Need Help
  • Stachu's avatar
    Stachu
    7 years ago

    I'd start with putting all the closing balances in a single table

    for comparison I'd just add new column to each table that would specify the period it relates to (e.g. Q1 FY1, Q1 HY1 etc. all in one column)

    if you have any other examples of tables sharing the same structure but being separated I would think about putting them together as well

v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

Hi bengia ,

 

What is your fact table and dimensional tables, based on your diagram, it seems like table "Closing Balance" has many-to-one relationships with other tables. And you want to filter or achieve values from other dimensional tables in "Closing Balance", right? So I would recommend you to re-organize your table relationship in a start schema, please refer to: https://en.wikipedia.org/wiki/Star_schema. In this senario, make sure that values in key columns is unique in your dimensional tables.

 

Regards,

Jimmy Tao