Hi @rajasekaro,
Please have a look at the below solution.
1) Create power Bi measures for the closing
ClosingV3 =
VAR Opening = MAX(account_transactions[APYC])
VAR CurrentDate = MAX(account_transactions[DATE])
VAR CurrentAccount = MAX(account_transactions[ACCOUNT])
VAR CumulativeAmount =
CALCULATE(
SUM(account_transactions[AMOUNT]),
REMOVEFILTERS(account_transactions),
account_transactions[ACCOUNT] = CurrentAccount,
account_transactions[DATE] <= CurrentDate
)
RETURN
Opening + CumulativeAmountOR
Closing_v4 =
VAR Opening = MAX(account_transactions[APYC])
RETURN
Opening +
CALCULATE(
SUM(account_transactions[AMOUNT]),
ALLEXCEPT(account_transactions, account_transactions[ACCOUNT]),
account_transactions[DATE] <= MAX(account_transactions[DATE])
) 2) Copy that measure in the table/matrix visual
Please consider as an accepted solution if worked or give some kudod.
if you want to create a column ,you can try this
@rajasekaro sorry to add another solution here, everyone else has done great work but I disagree with above solutions. Anything related to time intelligence should be handles using calendar/date table (as a best practice). Learn more about that, check here:
As a best practice, add a date dimension in your model and use it for time intelligence calculations. Once the date dimension is added, mark it as a date table on table tools. Check the related videos on my YT channel
Add Date Dimension
Importance of Date Dimension
Mark date dimension as a date table - why and how?
Time Intelligence Playlist
I will create a date dimension and use this to work with dates, and setup relationship of this table with the transaction/fact table on the date column.
Sum Amount = SUM ( Table2[AMOUNT] ) --just a base measure
RT Amount =
CALCULATE (
[Sum Amount],
FILTER (
ALLSELECTED ( 'Calendar' ), --change this will all if want to ignore any filter on date
'Calendar'[Date] <= MAX ( 'Calendar'[Date] )
)
)
Closing Value =
MAX ( Table2[APYC] ) + [RT Amount]
Cheers!
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
if you want to create a column ,you can try this
Hi @rajasekaro,
Please have a look at the below solution.
1) Create power Bi measures for the closing
ClosingV3 =
VAR Opening = MAX(account_transactions[APYC])
VAR CurrentDate = MAX(account_transactions[DATE])
VAR CurrentAccount = MAX(account_transactions[ACCOUNT])
VAR CumulativeAmount =
CALCULATE(
SUM(account_transactions[AMOUNT]),
REMOVEFILTERS(account_transactions),
account_transactions[ACCOUNT] = CurrentAccount,
account_transactions[DATE] <= CurrentDate
)
RETURN
Opening + CumulativeAmountOR
Closing_v4 =
VAR Opening = MAX(account_transactions[APYC])
RETURN
Opening +
CALCULATE(
SUM(account_transactions[AMOUNT]),
ALLEXCEPT(account_transactions, account_transactions[ACCOUNT]),
account_transactions[DATE] <= MAX(account_transactions[DATE])
) 2) Copy that measure in the table/matrix visual
Please consider as an accepted solution if worked or give some kudod.
Helpful resources
FabCon & SQLCon – Barcelona 2026
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Data Days 2026
Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
