mix 2 table for accounting

[Anonymous]

Hi Guys:

I have this 2 tables (a lot of accounts and levels, but I simplyfied for the example), the first one is a table with all the parents accounts and de second one have the breakdown with the details of the accounts. I am searching the way to have a matrix, having the example as the first level and when I click on the '+', power bi shows me the next level, but theres could be several levels. So I convert to number the account, removing the '-'.

I think that the next step could be some dax, saying "assets are all the accounts that are between 1-00-000 and 2-00-000, then, for the next level, current assets are the ones between 1-01-000 and 1-02-000"

[v-diye-msft]

Hi @Anonymous 

You might consider providing your dummy pbix that would be helpful for us to investigate it further. 

You can upload it to the onedrive for business and share the link here. please don't forget to disclose the expected results and remove the confidential info.

[Anonymous]

@v-diye-msft thank you for your help, sorry the delay, but my work and school are driving me crazy.

https://advanprocommx-my.sharepoint.com/:u:/g/personal/eduardo_s_advanpro_com_mx/EWXlLcpE75FLhVXhC_B...

Here is the link, please let me know if you could download it.

I have those 2 tables, The first one have all the accounts, so I put a filter, showing just the ones that have an "N" in the column "Acepta Datos". This is showing the fathers accounts, so I select a Matrix, and what I need is have it on levels, for example, the first level is the first number before the first "-", in this case the first level will have 10 rows (from 0 to 9), the second level should be selecting the "+" in the matrix and a list must go down with the next level, for example, if you select the row of number 1, a list will go down, showing the next level with all the accounts that begin with "1", but before the second "-", etc.  All the father accounts with the filter of "N" shouldnt have any amountm but the son accounts have a debit amount, so those should be the  sum of each level.

I hope I could explain myself

Kind regards

Eduardo Silva

[MFelix]

Hi @Anonymous ,

Believe this is the common parent child hierarchy check the links below:

https://www.daxpatterns.com/parent-child-hierarchies/

https://docs.microsoft.com/en-us/dax/understanding-functions-for-parent-child-hierarchies-in-dax