topic Re: Quantity for Last Process Step for each Order in DAX Commands and Tips

Quantity for Last Process Step for each Order

joshua1990 — Wed, 10 Jun 2020 08:00:18 GMT

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?

Re: Quantity for Last Process Step for each Order

joshua1990 — Fri, 12 Jun 2020 05:06:09 GMT

No idea?

Re: Quantity for Last Process Step for each Order

Anonymous — Fri, 12 Jun 2020 05:19:09 GMT

Hi joshua1990 ,

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

Regards,
Harsh Nathani

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

Re: Quantity for Last Process Step for each Order

Anonymous — Fri, 12 Jun 2020 05:28:07 GMT

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)