Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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/1NHSx1a4oN7X3hYK39o39RcaKuhZjYkLkh2OtDvnKx3o/edit#gid=0
Inventory Table Column Formulas are:
Solved! Go to Solution.
@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
@aramirez2 - Perhaps have a look at Days of Supply - https://community.powerbi.com/t5/Quick-Measures-Gallery/Days-of-Supply/m-p/635656#M318
Thanks @Greg_Deckler for your answer. It is a great exercise even though it is not very related to my issue.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
89 | |
81 | |
65 | |
65 | |
61 |
User | Count |
---|---|
170 | |
115 | |
100 | |
73 | |
67 |