Forum Discussion
AUDISU
Resolver III
Resolver IIIWeighted Average Cost in POWER QUERY
Hi All, Im new to power query and Im trying to calqulate Weighted Average Cost of materials. When I receive a new stock, avarage price shoul be (Cost of Available Stock + Cost of New Stock) / To...
AlB
Community Champion
Community ChampionHi AUDISU
1. Are you sure you want to do this in Power Query? Why?
2. Please show the expected result based on the sample data provided
3. Please share the sample data in text-tabular format instead of a screencap so the contents can be copied
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |
AUDISUResolver III
Resolver IIIHi,
Thank you for your reply.
Yes . I want to calculate the total cost of issued items base on wieghted average coast.
Date TypIn Price Qty Running TotalAvg Cost(Per Unit)Total Cost
| 1/01/2022 | In | 2 | 1000 | 1000 | 2.00 | - |
| 2/01/2022 | Out | -200 | 800 | 2.00 | 400.00 | |
| 15/01/2022 | Out | -300 | 500 | 2.00 | 600.00 | |
| 3/02/2022 | In | 3 | 1000 | 1500 | 2.67 | - |
| 8/02/2022 | Out | -500 | 1000 | 2.67 | 1,333.33 | |
| 10/02/2022 | Out | -100 | 900 | 2.67 | 266.67 |