topic Re: Cumulative Total in new Appended Table in DAX Commands and Tips

Cumulative Total in new Appended Table

Whitewater100 — Sat, 14 Sep 2024 19:06:56 GMT

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

Re: Cumulative Total in new Appended Table

Whitewater100 — Sun, 15 Sep 2024 00:08:13 GMT

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.

Re: Cumulative Total in new Appended Table

Anonymous — Mon, 16 Sep 2024 02:53:31 GMT

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.