Forum Discussion
Need help - developing weighted averages with variable ranges
Attached is a set of sample data that we frequently have coming out of our sales database. We would like to create a separate table with a weighted average (example is the table to the right).
Typically the data set will be 20-30k lines long so I'm needing help on how we set up the right formulas that can be cut and pasted into the data dump on a weekly basis.
Suggestions?
Hi
Three ways: Cell formulas, Power Query queries, Power Pivot Measures.
Many thanks! I'll work on it with a larger data set and see if this frees up some time for the team.
