Forum Discussion
Run-out Date Calculation
Here would be a simplistic version
First Run Out = CALCULATE(min('Table'[Attribute]),'Table'[Value]<0,'Table'[Measure]="Stock Coverage (EOB)")Without the involvement of the dates table yet (although that is always a good thing to have). see attached.
Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services.
Thanks for your hint. Please find below the relevant data for that topic - please note, that i entpivot the columns in the PowerQuery Editor.
Plant (Local) Material (Global) Calendar Day 01.12.2021 02.12.2021 08.12.2021 09.12.2021 10.12.2021 15.12.2021 03.01.2022 05.01.2022 06.01.2022 12.01.2022 13.01.2022 19.01.2022 20.01.2022 26.01.2022 27.01.2022 M0/1 815 Purchase Part Stock Coverage (EOB) PCE 11.000 11.000 4.500 4.500 -3.500 -9.000 -9.000 -14.500 -14.500 -19.500 -19.500 -24.500 -24.500 -29.000 -29.000 M0/1 815 Purchase Part Stock PCE 11.000 M0/1 815 Purchase Part Requirements PCE 6.500 8.000 5.500 5.500 5.000 5.000 4.500 M0/1 815 Purchase Part Supplier Orders PCE 7.500 7.500 1.000 5.000 5.000 4.500 5.000 M0/1 815 Purchase Part ASN Here would be a simplistic version
First Run Out = CALCULATE(min('Table'[Attribute]),'Table'[Value]<0,'Table'[Measure]="Stock Coverage (EOB)")Without the involvement of the dates table yet (although that is always a good thing to have). see attached.
Thanks a lot - is there a solution to create that date based on a measure too?
Reason behind is, that in a 2nd step i would like to add the ASN quantities (these reflects parts in transit) to the calculation which would move the run out to a later date
