Feb 10 2023 03:03 AM
Basically, I'm creating dashboard for currency Exhange but I'm in not in the front-end side yet still working on the foundations, I'm using power query to snapshot the data in particular table view based on their type.
I've certain type of averages stored in one source sheet I want to represent them in separate sheets via power query based on their weighted average.
Feb 11 2023 11:24 PM
weighted average in POWER QUERY
Advice needed on weighted averaging in power query or power pivot
How to calculate weighted average in an Excel Pivot Table?
Maybe these links will help you.
Thank you for your patience and understanding