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: t...
Need Help
joshua1990's avatar
joshua1990
Post Prodigy
6 years ago

No idea?

    • 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)