How to calculate weighted average in power query

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.