DAX Code to create a Group Total but also show the grouping details (Used for Business Central)

[Anonymous]

Hello All

I am trying to produce a chart of accounts that shares beginning and end total for a certain set.

I would like the chart to look like this (which visual is best and how do I do the indent). I have been using Matrix but I dont think this is the best option.

G/L Number          Description                          Amount

1000                      Income                                     -

    1001                  Income A                                100

    1002                  Income B                                 200

    1003                  Income C                                 100

1010                      Total Income                           4000

The data comes from General Ledger entries like this

No	Name	Account_Type	Totalling
1000	Income	Begin-Total
1001	Income A	Posting
1002	Income B	Posting
1010	Total Income	End Total	1001..1003

I hope this come through ok!

Thank you

[stevedep]

Hi,

Please see; 

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Chart-of-Accounts-Totalling/m-p/1135767#M1692...

Please mark as solution if this is what you are looking for.

Kind regards,

Steve.