Weighted Average Cost of Goods Sold Help!!!!!

[SonLeThai]

Hello Everyone,

Please does anyone have a sample of how to calculate the Weighted Average Cost of Goods Sold where there are

Open Inventory
Inventory purchased monthly
Monthly sales for each product

Summarily, all I want is a Dax formula for a weighted average cost of goods that is calculated at the end of every month for the company’s monthly closing.

I search a lot but can't solve my problem

Please help me.

Eg:

Pic is way to calculate Weighted Average Cost of Goods Sold.

Thanks

[amitchandak · Accepted solution]

@SonLeThai , to build one hand you have to use cumulative measure

example

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: https://youtu.be/nKbJ9Cpb-Aw

check you share weighted Avg formula

[SonLeThai]

Tks you @amitchandak  your susget give an idea to solve my solution.
that's great!!!