cancel
Showing results for
Did you mean:
Highlighted
New Member

## Using previous row result

Hi

In this table presented below I have two columns, being: "Saldo_Inicial" and "Saldo_Final".

In the first row, the "Saldo_Final" column shows a value that was calculated from an initial value of 5000000 in the "Saldo_Inicial" column.
However, from the second line down I need the value shown in the "Saldo_Inicial" column to always be the calculated value in the "Saldo_Final" column of the previous line.

How do I do that?

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Community Champion

## Re: Using previous row result

Hi @pedrocampos ,

You can create a recursive function to calculate all the "saldo_final" until the previous row like:

``````(_table as table, _saldo as number, _currentIndex as number, _index as number) as number =>
let
Saldo = _saldo + (_table{_index}[Valor] + _table{_index}[Saldo Inicial]),
Return =
if _index < _currentIndex - 1 then @Query1(_table, Saldo, _currentIndex, _index + 1)
else Saldo
in
Return``````

Be aware with the function name, it need to be called inside the function as well.

Also, create a custom column to call the function.

Did I answer your question? Mark my post as a solution!
Ricardo

Highlighted
New Member

## Re: Using previous row result

Hello.

THank you very much.

Below, I post the solution that I wrote based on your post.

``````(_table as table, _saldo as number, _currentIndex as number, _index as number, _index_anterior as number) as number =>
let

Saldo = (_saldo * (1+(_table{_index_anterior}[Indexador_valor])))-((_saldo * (1+(_table{_index_anterior}[Indexador_valor])))/(_table{_index_anterior}[N_Parcela])) + _table{_index}[Saldo_Partida],

Return =
if _index < _currentIndex - 1 then @Saldo_inicial(_table, Saldo, _currentIndex, _index + 1,_index)
else Saldo
in
Return
``````

3 REPLIES 3
Highlighted
Community Champion

## Re: Using previous row result

Hi @pedrocampos ,

You can create a recursive function to calculate all the "saldo_final" until the previous row like:

``````(_table as table, _saldo as number, _currentIndex as number, _index as number) as number =>
let
Saldo = _saldo + (_table{_index}[Valor] + _table{_index}[Saldo Inicial]),
Return =
if _index < _currentIndex - 1 then @Query1(_table, Saldo, _currentIndex, _index + 1)
else Saldo
in
Return``````

Be aware with the function name, it need to be called inside the function as well.

Also, create a custom column to call the function.

Did I answer your question? Mark my post as a solution!
Ricardo

Highlighted
Community Support

## Re: Using previous row result

If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly. If not, please kindly elaborate more. thanks!

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
Highlighted
New Member

## Re: Using previous row result

Hello.

THank you very much.

Below, I post the solution that I wrote based on your post.

``````(_table as table, _saldo as number, _currentIndex as number, _index as number, _index_anterior as number) as number =>
let

Saldo = (_saldo * (1+(_table{_index_anterior}[Indexador_valor])))-((_saldo * (1+(_table{_index_anterior}[Indexador_valor])))/(_table{_index_anterior}[N_Parcela])) + _table{_index}[Saldo_Partida],

Return =
if _index < _currentIndex - 1 then @Saldo_inicial(_table, Saldo, _currentIndex, _index + 1,_index)
else Saldo
in
Return
``````

Announcements

#### August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

#### Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

#### Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

#### Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors