I have an Accounts transaction file that has columns for Account Code, Accounting Year, Period and Amount.
The accounting Year is a four digit year number and the Accounting period is a two digit number (NOT the calendar month number)
I want to:
For Balance Sheet Codes create a separate table that contains a single unique accumulated total by for each of those combinations of those fields.
The range of codes will typically be for a maximum of three years (last year, this year and next year) and each total needs to contain the accumulated total from the very beginning.
Any help with the DAX code would be appreciated.