i have created a table of a long list of measures (dax calculations) for financial calculations. it has no relationship to any other tables.
as income statement / profit & loss items are presented with cummalative/running totals, the measures i created for profit & loss items look like this:
60000-Supplies = CALCULATE( SUM('finance'[Amount]), 'chart-of-acct'[Account_Group_Code]=60000)
since balance sheet items are supposed to presented at a particular point in time (i.e. not cummalative), i’m not sure how the dax calculations are supposed to be for them. also, how do i present it in reports for each month and each year. i’d appreciate any help for these.
tks & krgds, -nik