Forum Discussion
Inventory Change from Beginning Value
Hello all,
I'm having a difficult time calculating inventory change over time. I am trying to visualize a matrix where the earliest month I have data for will be my starting inventory value to then calculate additional units purchased minus billed. For whatever reason all it's doing is taking the beginning total, adding purchased then subtracting billed and giving that total by month. The expression is I'm needing is: Beginning Value + Purchased - Billed = EOM Inventory
For my model I have:
- Date table, marked as date
- Inventory table with the units and inventory date
- There is a relationship between these two tables
Here is what I'm expecting:
Here is my DAX:
CALCULATE(
SUM('Inventory'[Units]),
FILTER(
ALLSELECTED('Inventory'[Date]),
ISONORAFTER('Inventory'[Date], MAX('Inventory'[Date]), DESC)
)
)Hi,
PBI file attached.
Hope this helps.
Wap the EOM measure in an IF function.
EOM revised = If([Billed]=blank(),blank(),[EOM])
11 Replies
- parry2kSuper User
ajrodr82 how are the transactions tagged in the inventory table?
👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo
- ajrodr82Regular Visitor
- Ashish_MathurSuper User
Access Denied message.
- Ashish_MathurSuper User
Hi,
Share the download link of the PBI file.
- ajrodr82Regular Visitor