Cumulative Total in new Appended Table

[Whitewater100]

Hello Community:

I am trying to write a DAX calculated column to produce a Running Total result that will display the same results on my attached pbix (RT Inventory page). 

I would like to ask for help in producing this calculated column in the "Orders-and-Inv" table. I produced this table by appending the Store Orders and WHInv tables. You will see now the order quantities are negative and the beginning invenory numbers are positive.

Any further hwlp on this is greatly appreciated!
https://drive.google.com/file/d/1LghAfkhKOrx8WtqGUil10lRlUg6Viu5x/view?usp=sharing 

[Anonymous]

Hi @Whitewater100 ,

You can just create a new calculated column and use the measure as the value of the calculated column to get the positive numbers:

Column = [Bal_On_Hand]

The result is as follows:

Best Regards,
Zhu
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

[Whitewater100]

Hi: Please find he more coplete file with IDs for WH locations. Thank you.https://drive.google.com/file/d/1LghAfkhKOrx8WtqGUil10lRlUg6Viu5x/view?usp=sharing 

I hope this helps!

Thank you for any assistance.