Forum Discussion
Volume weighted Average inventory age
I have read through some previous posts but have not been able to apply the solution to my problem. This is a long standing problem and I currently calculate the answer, manually, when someone asks;...
v-joesh-msft
Solution Sage
Solution SageHi Anonymous ,
I'm a little confused by your description: "I want to calculate the volume weighted average age of the inventory in each bay. When inventory is removed, I want to calculate the volume weighted average age of the inventory removed. "
Could you share your calculation logic and your expected output? The calculation of the weighted average in the new quick measure in the desktop may be helpful.
About put all the mills into the same sheet, you can take a look at the video below:
Consolidate Excel Sheets with Power Query
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.