Need to create a new column showing the "Inventory Balance" on each change of "2nd Item Number"
I did it with an excel formula, =IF(A700=A699,J699-D700,E700-D700)
Needed to order the "2nd Item Number" by date
If "2nd item number is equal" to previous cell, deducts "Demand" from previous "inventory balance" if not deducts "demand" from "total inv"
Wonder if this can be accomplished directly in Power Query
