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

Anonymous — Wed, 27 May 2020 08:03:06 GMT

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

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

stevedep — Tue, 02 Jun 2020 10:45:05 GMT

Hi,

Please see;

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

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

Kind regards,

Steve.

topic Re: DAX Code to create a Group Total but also show the grouping details (Used for Business Central) in DAX Commands and Tips

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

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