Forum Discussion

Bart_1989's avatar
Bart_1989
Frequent Visitor
9 years ago

Inventory age based on batch manufacturing date

Hi everyone,   I have a table with inventory transactions that I use to calculate movements as well as inventory levels per day.   Quantity:=SUM(InventTrans[Qty])   Stock Quantity:=CALCULATE( ...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Bart_1989,

 

Could you please post a sample here? 

 

1. Did you mean (26 + 2)/(2 batches) = 14 of 11.06 and 3/(1 batch) = 3 of 12.06 ? 

2. What are batches? Measure, column or calculated column?

 

Best Regards!

Dale

  • Bart_1989's avatar
    Bart_1989
    Frequent Visitor
    9 years ago

    Hi v-jiascu-msft,

     

    You are right. I would like it to show me (26+2)/2 = 14 on the 11th and 3 on the 12th.

    A batch is just a number available in my source data. It's currently just a normal column.

     

    I'm not sure what you require in the example. If the above information is not enough, can you please let me know?

    Thank you!

     

    Regards,

    Bart