Forum Discussion
Rolling Inventory
I have tried to get this to work and have searched all available resources to figure out how to transfer ending inventory to the next day's beginning inventory. I have a table (Inventory) that is al...
kjkreik , Inventory need to be calculated in a cumulative manner
Beginning of Time(BOT) Inventory + Purchase till date from BOT - Sales till Date
Inventory / OnHand
[Intial Inventory] + CALCULATE(SUM(Table[Ordered]),filter(date,date[date] <=Min(date[date]))) -
CALCULATE(SUM(Table[Sold]),filter(all(date),date[date] <=Min(date[date])))
Inventory / OnHand
CALCULATE(firstnonblankvalue('Date'[Month]),sum(Table[Intial Inventory]),all('Date')) +
CALCULATE(SUM(Table[Ordered]),filter(all(date),date[date] <min(date[date]))) -
CALCULATE(SUM(Table[Sold]),filter(all(date),date[date] <min(date[date])))
Power BI Inventory On Hand: https://youtu.be/nKbJ9Cpb-Aw