Beginning of Month Value using Last Month Value

[bryantmikdbi]

Hello - I'm trying to get Beg of Month Inventory to populate based on the last month Beg of Month Inv value.  Below is a simplified version of the data and desired result.

Data Table:

Brand	MonthID	Inv U
A	202105	10
A	202106	20
A	202107	50
A	202108	40
B	202105	20
B	202106	60
B	202107	30
B	202108	10

This table is joined to a data table (below) - joined by Monthid:

MonthID	Month
202105	May
202106	June
202107	July
202108	August
202105	May
202106	June
202107	July
202108	August

Desired Result:

Brand	Month	Inv U	BOM Ivn U
A	May	10
A	June	20	10
A	July	50	20
A	August	40	50
B	May	20
B	June	60	20
B	July	30	60
B	August	10	30

Basically trying to get the BOM Inv U based off the last month Inv U value.

Any help would be great!

[Tanushree_Kapse]

Hi @bryantmikdbi ,

Measure_lastmonth= CALCULATE (SUM(Inv U), PREVIOUSMONTH(TABLE_2[Month]))

I hope this helps.

Mark it as a solution if I answered your question.