Stock at end of Month

[faiqsadiq1]

Hi . I hope you would be fine .I need to find Stock at end of the month and its formula is stock of beginning of month+ shipment that month-forecast.Stock of beginning of month is unrestricted + Transit and Transfer in 1st picture,Shipment that month is production completion date(Its quantity) + 1 Week and Subtract forecast from it.


Can any one help me on it.I am unable to find result.

[NikhilChenna]

Hi @faiqsadiq1 ,
I think can use below logic and write the measure ,

Var a = 
Add the 2 column unrestricted + Transit and Transfer

Var stockofbeginningofmonth=
CALCULATE(
          SUM(a),
          DATEADD('Date Dimension'[date],-1,MONTH)
)

var sforcast = SUM(forcast)

Var shipmentthatmonth = create a calculation for this production completion date(Its quantity) + 1 Week and Subtract forecast

RETURN 
( stockofbeginningofmonth + shipmentthatmonth ) - sforcast 

Regards,
Nikhil Chenna

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

[faiqsadiq1]

Hi Nikhil,
It didnt went well .Inventory trend is not showing ok results.
Or I guess i am unable to communicate

[Anonymous · Accepted solution]

Hi @faiqsadiq1 ,

Please share some sample data in text format and expected result so that we could test formulas.

Best Regards,

Jay