Forum Discussion
Running Sum for Balance Sheet
- 2 years ago
Hi mohsinmasood - Create a running sum (cumulative total) for a Balance Sheet , hope you already have the seperate date tables , if not please create a new date table.
Create a new measure for Accumulated Profit/Losses Running Sum:
Accumulated Profit/Losses Running Sum =
CALCULATE(
SUM(BalanceSheet[Accumulated Profit/Losses]),
FILTER(
ALLSELECTED(DateTable),
DateTable[Year] <= MAX(DateTable[Year])
)
)similarly create for Netincome running and totals as below:
Total Running Sum =
CALCULATE(
SUM(BalanceSheet[Total]),
FILTER(
ALLSELECTED(DateTable),
DateTable[Year] <= MAX(DateTable[Year])
)
)Once created , you can achieve a running sum for Balance Sheet data
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Can you help me for equit as well as per my above requirements?