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 b...