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...
ronrsnfld
Super User
Super UserYoucef_Data Could you please add an explanation of how your solution improves on the one I supplied a year or two ago?
In the given script, there is a grouping operation based on the "ItemID" (material) and then the calculations for running total and weighted average cost are performed within each group. This suggests that the calculations are done separately for each distinct "ItemID" (material) .🙏
- ronrsnfld
Thank you for clarifying. I guess the OP was either happy with the grouping, or was able to adapt it to his actual data.