Forum Discussion
Solved
GL Accounts & GL Entry Relationship - PowerBI
I am trying to create a trial balance sheet using PowerBI. (not using content pack as it is not available for NAV2009). In NAV Chart of Accounts there are Head Accounts and Sub-Accounts. IN S...
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.
ImkeF
Community Champion
Community Champion1) 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.
Thanks it worked :)
