0
Hello.
My personal doubt is how to calculate the weighted mobile average, in Power Bi, the problem is when I have to calculate the cost of the unit sold, multiplying by the average cost, and deducting this value from the Total.
Link with template file:
https://drive.google.com/drive/folders/1F4X244y3NXB-hnM8rOuqE1UMLVU_3msC?usp=sharing
Example:
Initial = 100 Product Units X, at the cost of $500.00 the lot
Purchase of 200 X Product Units at a cost of $1,150 per batch
The average cost of Product X will be:
R $ 500,00 + R $ 1,150,00 divided by (100 + 200) units
= R $ 1.650,00: 300
= $5.50 a piece
In effective sequence at a drop of -150 units
= 120 multiplied at the cost of $5.50 = -660
Accumulated cost goes from R $ 1650,00 - 660 = 990 and the total 300 units - 120 = 180, maintaining the average cost, until new acquisition.
Even the first sale works normally, but from the second sale the media distorts.