Quantity for Last Process Step for each Order

[joshua1990]

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 Nr	Order Date	Article	Area
100	01.01.2019	XCF9902	Cabines
101	01.04.2019	XG9901	Doors

tblManufacturing

OrderNr	Date	Step	Quantity
100	05.01.2019	1	50
100	07.01.2019	2	49
100	15.01.2019	3	47

How can I determine the last quantity for each order?

[joshua1990]

No idea?

[harshnathani]

Hi @joshua1990 ,

https://community.powerbi.com/t5/Community-Blog/Getting-Previous-Values-in-Power-BI-Part-1/ba-p/1143...

Regards,
Harsh Nathani

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

[harshnathani]

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)