Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Running total subtracting historical measures

Hi all,

 

I have a table of stock movements by date. The latest stock movement is the closing balance. So in the below example, the closing balance was 159.1m. I want to calculate the historical stock balances by subtracting the previous days stock movements.

 

So the stock balance for 8th Feb would be 158.1m, then 156.1m for 7th Feb and so on.

 

How could I achieve this? I can calculate a running total which looks backwards but this adds the stock movements and does not subtract.

 

Thanks

 

Mike

 

Mike

Need Help

11 Replies

  • LivioLanzo's avatar
    LivioLanzo
    Icon for Solution Sage rankSolution Sage
    7 years ago

    Hi Anonymous

     

    can you post a dataset which can be copy pasted?

     

    thx

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi,

         

        See above - thanks

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous 

    How would you like to make stock balances change with other dimensions selected (such as product category)?

    You could use "allselected" in your meausre to replace "ALL" function, then when you select different dimensions, it shows different results.

     

    If it doesn't solve your probelm, please show more details as LivioLanzo's last post suggested.

     

    Best Regards

    Maggie