Running total with List.Accumulate with calculations

[SebSchoon1]

Hello,

I have a question concerning a function that I have never used before

List.Accumulate. However i think my case can be handled by this function.

Here below de desired logic.

Something like a running total but according to informations located in multiple columns.

i don't no if it is really understandable 🙂

[lbendlin]

Yes, that is one of the options to handle your scenario.  Would you mind providing some sample data in usable format?

[SebSchoon1]

Hello here the link wetrasnfer with a simple file in which i've made the table as showed previously as if final result from my queries.

https://we.tl/t-vA9uZ94EVq 

[lbendlin]

Thank you for the sample data.  You may also want to provide an index column so that Power BI knows what the row order is. 

Please explain how you link lines 1 and 3.  Is it based on the first positive stock difference?

[SebSchoon1]

Hello @lbendlin 

Hope you are doing well.

Yes the idea is that the value from -5 on first warehouse encounter value+4 then -5 +4 =-1 

At that time, value from first warehouse is -1 

And the next value in line 4 is 1. 

So same way -1 +1 =0

Etc 

[SebSchoon1]

Hi @lbendlin , wow great,

i'll try to prepare this asap ^^