Calculating Balance from previous data

[Md_Fahad_Rahman]

I need to calculate the balance in each row of the “Balance” column, It could be Previous Balance+Cash In-Cash Out. How can I do that?

[Aurelien]

Hi @Md_Fahad_Rahman

I suggest you have a look on this post:

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT() Tips & Tricks 💡

How do I get the last row of this thing only? MAXROW( "My Table", "_ROWNUMBER", ([_THISROW].[Thing] = [Thing]) ) Replace My Table with the name of the table whose row you want; and Thing with the name of the column containing a value that identifies the thing you want (e.g., Order ID).

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT() Tips & Tricks 💡

Nope. Try: INDEX( ORDERBY( FILTER( "My Table", ([_THISROW].[Thing] = [Thing]) ), [_ROWNUMBER], TRUE ), 2 )