Forum Discussion

Grunstra's avatar
Grunstra
Regular Visitor
9 years ago
Solved

Display\Find The first Date that Inventory QTY goes Negative based on Running Net Inventory Totals

I need a way to find when an Item running Inventory On Hand QTY first goes negative and display its Due_date.. Example see screen shot where I have Running Inventory totals per Orders. I have a Due_D...
Need Help
Tips and Tricks
Tutorial Requests
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi Grunstra,

    I thought your resource table in same table, I understand now. Please create a measure using the formula, then add it to your table report.

    New Due-Date = MINX(FILTER('OrdersOpen-All','OrdersOpen-All'[Net Inv RT]<0),'OrdersOpen-All'[due_date])



    Best Regards,
    Angelia

     

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Grunstra,

I thought your resource table in same table, I understand now. Please create a measure using the formula, then add it to your table report.

New Due-Date = MINX(FILTER('OrdersOpen-All','OrdersOpen-All'[Net Inv RT]<0),'OrdersOpen-All'[due_date])



Best Regards,
Angelia

 

Grunstra's avatar
Grunstra
Regular Visitor
9 years ago

Sweet!! Thanks.  How can I also get the Order QTY related to the due when it first went Negative?

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi Grunstra,

    I use the min function, it has calculated the earliest date went Negative. 

    Best Regards,
    Angelia

  • Grunstra's avatar
    Grunstra
    Regular Visitor
    9 years ago

    Any way to get the ON Hand Inventory QTY on that Due Date?