topic Re: Weighted Moving Average in DAX Commands and Tips

Weighted Moving Average

Anonymous — Wed, 15 Sep 2021 00:28:28 GMT

Weighted Moving Average

Hello.

Personal, my doubt is how to calculate the weighted moving 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 Units of Product X, at the cost of R$ 500.00 per batch

Acquisition of 200 Units of Product X, at the cost of R$ 1,150.00 per lot

The average cost of Product X will be:

BRL 500.00 + BRL 1,150.00 divided by (100 + 200) units

= BRL 1,650.00: 300

= BRL 5.50 per unit

In the effective sequence to a write-off of -120 units

= 120 multiplied at the cost of R$ 5.50 = -660

Accumulated cost goes from R$ 1650.00 - 660 = 990 and the Total of 300 units - 120 = 180, maintaining the average cost, until a new acquisition.


In the example below, where it is 7.19 the correct is 5.81, which would be R$ 1650.00 - 660.00 +1800 = 5.81, if there is no sale Works perfectly.

Re: Weighted Moving Average

daxer-almighty — Tue, 31 Aug 2021 18:16:42 GMT

Anonymous

Would you please format the post in a convenient way to read it? Currently it requires people to scroll across and is not very readable. The font is weird as well. Thanks.

Re: Weighted Moving Average

Anonymous — Tue, 14 Sep 2021 23:23:04 GMT

Can anyone help me with this question?

Re: Weighted Moving Average

daxer-almighty — Tue, 14 Sep 2021 23:51:00 GMT

Your visual does not look like the one you've shown above:

Re: Weighted Moving Average

Anonymous — Wed, 15 Sep 2021 00:29:41 GMT

I adjusted, because I had improved the formula. Thanks

Re: Weighted Moving Average

daxer-almighty — Wed, 15 Sep 2021 08:06:47 GMT

I don't understand now... You've improved the formula, so it is already working fine?

Re: Weighted Moving Average

Anonymous — Wed, 15 Sep 2021 10:23:05 GMT

No, it's still wrong, note in the image I updated, the correct result is from excel.