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
Bart_1989's avatar
Bart_1989
Frequent Visitor
9 years ago

Hi v-jiascu-msft,

 

Thanks for your answer and your effort!

I have meetings for the next upcoming days, but will surely try your solution as soon as I can. I will get back to you when I did!

 

Regards,

Bart

Bart_1989's avatar
Bart_1989
Frequent Visitor
9 years ago

Hi v-jiascu-msft,

 

Unfortunately, I can't get it to work and I decided to write a state table in SQL instead.

Cross joining DatePhysical and InventTrans is a way I don't really want to go in, as the InventTrans table can contain millions of records.

 

I want to thank you a lot for your help though.

 

Regards,

Bart

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Bart_1989

     

    Hi Bart,

     

    My pleasure. Cross joining with a filter may work. I tested it with a large table once. If you want to try, backup your work first.

     

    Best Regards!

    Dale