Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Inventory Allocation

Looking for some table and report help on how to make a Inventory Allocation report to help us ship inventory to oldest order first.   I have an inventory onhand report and I would like to take the...
Inventory
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Im not sure exactly what you are asking for but here is what the to tables look like in BI.

 

 

I hope this helps.

kumar27's avatar
kumar27
Icon for Advocate V rankAdvocate V
5 years ago

As you said

 

Currently I do this in Excel by sorting orders by oldest date and then smallest order number.  Then taking inventory ohand and using the formula  J2 - G3 to start off then for the rest use formual in column h as "Example H4-G4"

 

The same thing can be done in Power BI query editor where the columns can be sorted and then you can add the calculated column to get H4-G4.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    kumar27

     

    Thank you for the insight on this being able to be done in query editor but I am really new with this stuff and am having an issue on how I would do the calulated column in query editor when they are to differnt tables.