topic Re: Calculate current inventory of cylinders from the first delivery to the most recent in DAX Commands and Tips

Calculate current inventory of cylinders from the first delivery to the most recent

BudMan512 — Fri, 23 Feb 2024 15:47:36 GMT

Hi,

I have a table of data that shows the number of cylinders delivered to various customers, and the number of cylinders picked up. It also includes a calculation of the difference between the two.

I need to add a column for the Current Inventory which dates back to the very first delivery as can be seen below.
Would someone kindly provide me with the DAX to determine the Current Inventory?

A link to the data is below.

CYLINDERS.xlsx

Thanks,

Bud

Re: Calculate current inventory of cylinders from the first delivery to the most recent

lbendlin — Fri, 23 Feb 2024 23:30:58 GMT

Re: Calculate current inventory of cylinders from the first delivery to the most recent

BudMan512 — Mon, 26 Feb 2024 16:33:58 GMT

lbendlin

Thank you, that worked as requested!