Reducing Inventory by Demand as time goes

[mafaber]

Hi,

I have a table with the amount of Inventory we have for the specific item, and the delivery plan by week. What I'd like to show is how much more we need from each product to be able to satisfy the orders.

For example, let's say I have an inventory of 10 of Item A and I'm planning to ship 1 every week for the next 15 weeks.

Then in a matrix, where the row is Item A, and the columns are the weeks I'd like to show 0 for the next 10 weeks and 1 for the 11-15th weeks as the current inventory no longer covers them.

Sample data: https://drive.google.com/open?id=1KqpuBswzdDOYd2cpp-2d0_ML81E4modd

or:

I see two possible solution, I could do it with a measure, or create a custom column in the query where instead of the actual inventory I have, I show the predicted inventory that I will have on that week considering actual - delivered earlier. Any idea how to translate that to DAX or M language? 🙂

Thank you for your help!

[v-diye-msft]

Hi @mafaber ,

Could you please confirm the result you want is :

" the columns are the weeks I'd like to show 1 for the next 10 weeks and 0 for the 11-15th weeks as the current inventory no longer covers them." ??