Forum Discussion
GL Accounts & GL Entry Relationship - PowerBI
1) Filter Column "Totalling" where rows are not empty
2) Add a column "Custom" where you extract start and end value like this: Text.Split([Totalling], "..").
3) Add another column that creates all numbers within that intervall: {Number.From([Custom]{0})..Number.From([Custom]{1})}
4) Expand that column to new rows. This will give you 2 columns for your hierarchy.
Community ChampionHi PowerChange2021 ,
I would recommend to open a new thread on your specific topic.
For example, currently I don't understand how to determine the head accounts. So it would be ideal if you could provide a sample file (in Excel for example) where you provide sample data of your input structure and the desired output.
Very good idea! But before that, could you explain how you would do the hierachy in the mentioned step 4:
"4) Expand that column to new rows. This will give you 2 columns for your hierarchy."
Because in step 1) we filter all rows not empty, and thus we do not have names for the columns we end up with?