Finding the rolling balances for a bank Statements (best approach)

[XhevahirMehalla]

Hello -

I have created a report using PBI builder - to generate a bank statements. All is looking good and one last remaining is:

Balance for each day (this should include ) the balance for that day after substructing the value of the current transaction.

I have the first day balance and the last day balance. 

I want to track back from last day of the month to the first day of the month. 

How do I construct this?

A measure create on Desktop or a measure create on PBI builder?

Please help!

Thanks

Xhev

[v-sgandrathi · Accepted solution]

Hi @XhevahirMehalla,

You can determine the daily running balance for your scenario by calculating it directly in Power BI Desktop before exporting to Report Builder. This method is generally more dependable and easier to manage than doing the calculation within the paginated report.

If you have the closing balance and need to work backwards from the end of the month, you can set up a measure in your data model as follows:
Daily Balance :=
VAR ClosingBal =
MAX ( 'Balances'[ClosingBalance] )
VAR MovementsAfterDate =
CALCULATE (
SUM ( 'Transactions'[Amount] ),
FILTER (
ALL ( 'Date'[Date] ),
'Date'[Date] > MAX ( 'Date'[Date] )
)
)
RETURN
ClosingBal - MovementsAfterDate

Create this measure in Power BI Desktop and use it directly in Report Builder. It ensures the logic stays consistent and avoids recomputing inside the paginated layer.

Thank you.

[v-sgandrathi]

Hi @XhevahirMehalla,

Just wanted to follow up and confirm that everything has been going well on this. Please let me know if there’s anything from our end.
Please feel free to reach out Microsoft fabric community forum.

[v-sgandrathi · Accepted solution]

Hi @XhevahirMehalla,

Just wanted to follow up and confirm that everything has been going well on this. Please let me know if there’s anything from our end.
Please feel free to reach out Microsoft fabric community forum.

[v-sgandrathi · Accepted solution]

Hi @XhevahirMehalla,

You can determine the daily running balance for your scenario by calculating it directly in Power BI Desktop before exporting to Report Builder. This method is generally more dependable and easier to manage than doing the calculation within the paginated report.

If you have the closing balance and need to work backwards from the end of the month, you can set up a measure in your data model as follows:
Daily Balance :=
VAR ClosingBal =
MAX ( 'Balances'[ClosingBalance] )
VAR MovementsAfterDate =
CALCULATE (
SUM ( 'Transactions'[Amount] ),
FILTER (
ALL ( 'Date'[Date] ),
'Date'[Date] > MAX ( 'Date'[Date] )
)
)
RETURN
ClosingBal - MovementsAfterDate

Create this measure in Power BI Desktop and use it directly in Report Builder. It ensures the logic stays consistent and avoids recomputing inside the paginated layer.

Thank you.

[parry2k]

@XhevahirMehalla you can use runningvalue  function RunningValue function in a paginated report - Microsoft Report Builder & Power BI Report Builder | M...