Forum Discussion

aramirez2's avatar
aramirez2
Helper I
6 years ago
Solved

Predict Future Inventary

Hello.   I am creating Inventory Table mixing real data for the past days and predicted data for the future days. I have these 3 tables:   https://docs.google.com/spreadsheets/d/1NHSx1a4oN7X3hYK3...
Need Help
  • aramirez2's avatar
    aramirez2
    6 years ago

     

    v-lili6-msft  Sorry I forgot to open the spreadsheet. However I have already found the solution

    Sf = VAR Sf = LOOKUPVALUE(PASTINVENTORY[Sf], PASTINVENTORY[Date], MAX(PASTINVENTORY[Date]), PASTINVENTORY[Product], inventory[productId]) 
var curdate = inventory[date] 
var lastdate1 = MAX(PASTINVENTORY[Date]) 
var io = CALCULATE(SUM(inventory[income])-SUM(inventory[outcome]),FILTER(ALL(inventory),AND(inventory[date] <= curdate,inventory[date] >= lastdate1))) 
var a = IF(inventory[date]<TODAY(), LOOKUPVALUE(PASTINVENTORY[Sf], PASTINVENTORY[Date], inventory[date], PASTINVENTORY[Product], inventory[productId]), Sf+io) 
RETURN a

     

  • aramirez2's avatar
    aramirez2
    Helper I
    6 years ago

    Thanks Greg_Deckler  for your answer. It is a great exercise even though it is not very related to my issue.