Balance sheet question

[quickbi]

Hi all,

I need your help because I'm doing a balance sheet.

I have an Excel file where I assign the corresponding accounts to each line in the structures. In this mapping table, I have account numbers with 2, 3, or 4 characters. Then, in the BS_ledger, I have all the accounts with their balances, but they are 9 digits long.

The problem arises, for example, when the inventory line corresponds to the sum of all accounts that start with 43. Then, the tax line includes 4701 and 4709, and you subtract 567.

How would you go about doing this?

Thank you very much.

[rajendraongole1]

Hi @quickbi -Can you please provide some sample data for reference , so that will analyze and share the expectations.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[quickbi]

YEs By the moment I can give screen shots because its a draft done in excel that I want to do it  in PBI.

This is the balance sheet structure:

as you can see in account group column there are some group accounts, with 3 or 4 digits.
This is an example coming from the balance sheet ledger:

You can see grouped accounts depending on the digits bs_acct_4 for 4 digits, bs_acct_3 for 3 etc.
I want to create a table using BS structure as a dimensions and values coming from BS_ledger. 
The DAX that I want to create is, depending on the values coming from the structure I 'll have to choose between  2,3 or 4 digits sum of accounts

[Anonymous]

@rajendraongole1 Thanks for your contribution on this thread.

Hi @quickbi ,

Thanks for your reply. Base on your description, there are two sheets "balance sheet structure" and "balance sheet ledger". And you want to achieve the same output in Power BI with the one in the excel. The account_group with 4 digits, 3 digits and 2 digits corresponed to the bs_acct_4,bs_acct_3 and bs_acct_2 in the sheet "balance sheet ledger"? What's your expected result? Could you please provide some raw data in your tables(exclude sensitive data) with Text format and explain the expected result with more details(examples, screenshot etc.) base on your sample data? It would be helpful to find out the solution. You can refer the following link to share the required info:

How to provide sample data in the Power BI Forum

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards