Forum Discussion
Automatically calculated financial statement starting from transactions list
Hi pierpa ，
If the structure already exists in a table and the size of the table is smaller than 1G,you can directly connect it with desktop by import,otherwise import all the related tables to desktop,then create the model you need in desktop.
Kelly
Hi v-kelly-msft thank you for your reply, the problem is not importing the data, but create the structure of the financial statement by automatically recreate the hierarchy of nodes, elements and account.
So, I need to arrive to Net Earnings, which is the subtraction and the sum of different elements (node), every element (Expenses), is the aggregation of a lot of accounts (Social media expenses), wich is an aggregation of transactions (social media expenses 500$ 12/12/2019
To do it by just importing a file i would need to create a table where for every node there is a parent, the parent of the parent, etc.
| Node | Parent 1 | Parent 2 | Parent 3 | Parent 4... |
| N0015 | N0010 | N0005 | N0002 | N0000 |
Then, by knowing the account associated to every node it is possible to put all the transactions in the correct node, sum every transaction in a node and by sorting them, recreate the income statment.
But building a table with the hierarchy of the nodes by hands is almost impossible. As stated before there are more than 300 nodes, so I'm looking for a better way to do it. As for now I only have a list of all the nodes and the first parent of each node.
Hi pierpa ，
I guess the blog below will help.
https://bondarenkoivan.wordpress.com/2016/09/09/unfold-child-parent-hierarchy-in-power-query/
Best Regards,
KellyDid I answer your question? Mark my post as a solution!