Running total with List.Accumulate with calculations

Question

Hello,&nbsp;I have a question concerning a function that I have never used before&nbsp;List.Accumulate. However i think my case can be handled by this function.Here below de desired logic.&nbsp;Something like a running total but according to informations located in multiple columns.&nbsp;i don't no if it is really understandable 🙂

lbendlin · Answer

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

sebschoon1 · Answer

Hi&nbsp;lbendlin&nbsp;, wow great,&nbsp;i'll try to prepare this asap ^^

sebschoon1 · Answer

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.&nbsp;https://we.tl/t-vA9uZ94EVq&nbsp;

lbendlin · Answer

Thank you for the sample data.&nbsp; You may also want to provide an index column so that Power BI knows what the row order is.&nbsp;
Please explain how you link lines 1 and 3.&nbsp; Is it based on the first positive stock difference?

sebschoon1 · Answer

Hello lbendlin&nbsp;&nbsp;Hope you are doing well.&nbsp;Yes the idea is that the value from -5 on first warehouse encounter value+4 then -5 +4 =-1&nbsp;&nbsp;At that time, value from first warehouse is -1&nbsp;&nbsp;And the next value in line 4 is 1.&nbsp;&nbsp;So same way -1 +1 =0&nbsp;Etc&nbsp;

Forum Discussion

Running total with List.Accumulate with calculations

5 Replies

Related content

DataSource.Error List.Accumulate

Calculate Run Rate

Running Maximum

List.Accumulate & Table.AddColum with Iteration Step Counter

Running sum