assigning ending inventory of current month as beginning inventory as a next month

[crnswengineer]

i need to assign ending inventory of current month as beginning inventory as a next month. i have write a measure to calculate it.here as measure:(the problem is probably i have used all values as a measure and i want to calculate next month from previous month but it is row based calculation. it can not tranfer the value because of this)

beginning =

VAR currentMonth =

SUM ( 'table[Total stock] )

VAR nextMonth =

CALCULATE (

SUM('table[Total stock])+[dumb order]

FILTER (

ALL( dates ),MONTH ( dates[Month] )

= MONTH ( SELECTEDVALUE ( dates[Month] ) ) + 1

)

)

RETURN

currentMonth+nextMonth

[daXtreme · Accepted solution]

Hi @crnswengineer 

If you use the Search box on this page above and type something like "inventory," you'll find a lot of solved problems like this. One potential solution would be:

Solved: Inventory Stock_Balance and cost calculation_DAX - Microsoft Power BI Community