Forum Discussion
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...
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
hi aramirez2
The file you uploaded needs permission, please upload again.
and you could also have a look this blog:
https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/
Regards,
Lin
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