Forum Discussion

joshua1990's avatar
joshua1990
Post Prodigy
6 years ago

Quantity for Last Process Step for each Order

Hello everyone!

For our manufacturing area I am working on a calculation of the WIP.

For this I need the quantity for each order based on the last process step.

I have the following two tables:

tblOrders

Order NrOrder DateArticleArea
10001.01.2019XCF9902Cabines
10101.04.2019XG9901Doors

 

tblManufacturing

OrderNrDateStepQuantity
10005.01.2019150
10007.01.2019249
10015.01.2019347

 

How can I determine the last quantity for each order?

 

Need Help

3 Replies

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi joshua1990 ,

         

        You can create a Calculated Column in Manufacturing Table.

         

        Last Quantity = CALCULATE(Max(Manufacturing[Quantity]),FILTER(Manufacturing,Manufacturing[OrderNr] = EARLIER(Manufacturing[OrderNr]) && Manufacturing[Date] = MAX(Manufacturing[Date])))
         
         
         
         
         

        Regards,
        Harsh Nathani

        Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)