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

Stachu's avatar
Stachu
Community Champion
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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Tthanks so much for reccomendation of merging into a single table.

    ive created a single table and now its worked for me. i can now trend data and it looks flash.

     

    thanks!