Forum Discussion

tobisw's avatar
tobisw
Regular Visitor
4 years ago
Solved

Run-out Date Calculation

EDIT: How can i add a PBIX Testfile to that message? Hello, i´m working on a run-out date calculation in which we would like to see, on which date the stock coverage for different part number goes ...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago

    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.

tobisw's avatar
tobisw
Regular Visitor
4 years ago

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

lbendlin's avatar
lbendlin
Super User
4 years ago

Sorry should have specified that my sample code was for a measure.