In our accounts system there is a facility that allows users to define templates for the production of mainly, but not exclusively, P & L Accounts and Balance Sheets.
Our approach to templates is very different to the one shown in the various courses you offer.
Our templates allow users to define the calculation rules for sub totals and grand totals.
There is one calculation command that I am struggling with the DAX for is the one that allows users to sum a range of lines in the report.
I have attached the pbix file and if you look at the “Template - Revenue” there is a ready made template which is hopefully self explanatory.
I have created a Measure in the Profit and Loss Measures Section and the DAX measure is Revenue Data Value.
I anticipate creating a virtual table to contain the total of Nominal Account Codes from NlTransactionsPosted that are specified in the range of lines to be summed up.
I am really struggling to get that DAX syntax sorted properly and any help will be extremely welcome.
Accounts.pbix (1.2 MB)