topic Stock at end of Month in DAX Commands and Tips

Stock at end of Month

faiqsadiq1 — Thu, 24 Nov 2022 10:24:20 GMT

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.

Re: Stock at end of Month

Anonymous — Thu, 24 Nov 2022 09:55:22 GMT

Hi faiqsadiq1 ,

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

Best Regards,

Jay

Re: Stock at end of Month

NikhilChenna — Thu, 24 Nov 2022 10:37:25 GMT

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!

Re: Stock at end of Month

faiqsadiq1 — Thu, 24 Nov 2022 10:51:47 GMT

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