Forum Discussion

amitchandak's avatar
amitchandak
Super User
3 years ago

dswinden , You have to use a cumulative approach

 

Inventory / OnHand
[Intial Inventory] + CALCULATE(SUM(Table[Ordered]),filter(date,date[date] <=maxx(date,date[date]))) - CALCULATE(SUM(Table[Sold]),filter(date,date[date] <=maxx(date,date[date])))

Inventory / OnHand
CALCULATE(firstnonblankvalue('Date'[Month]),sum(Table[Intial Inventory]),all('Date')) + CALCULATE(SUM(Table[Ordered]),filter(date,date[date] <=maxx(date,date[date]))) - CALCULATE(SUM(Table[Sold]),filter(date,date[date] <=maxx(date,date[date])))

 

Power BI Inventory On Hand
Power BI Inventory On Hand: https://youtu.be/nKbJ9Cpb-Aw

dswinden's avatar
dswinden
Helper II
3 years ago

Hi amitchandak as always, appreciate you are usually one of the first to reply!

WOuld you mind editing that DAX for the fields in my table above?  Thank you!