Check out the LOOKUP() function as it allows you to reference other rows in your view: https://onlinehelp.tableau.com/current/pro/desktop/en-us/help.htm#functions_functions_tablecalculation.html?Highlight=lo…
Hope that helps!
Here’s a view:
The Balance is computed using a formula with PREVIOUS_VALUE() which lets Tableau carry forward values.
The New Value A calculation uses LOOKUP() as Joshua had referenced to use the prior month’s Balance.
This helps almost for my solution, but small change here, in my data for everymonth value A is constant in that case how the calculation should be done for Balance.
Thanks for help in advance once again.
I don't understand. In what you'd provided value A was the prior month's balance, so how is it a constant?