Weighted Average / SUMPRODUCT

[dalben]

Hi,

I'm trying to generate a column with weighted average within power query. I can do it simply enough in EXCEL using

=SUMPRODUCT([Price],[Qty])/SUM([Qty])

but I can't work out how to do that within powerquery. If anyone can shed some light it would be great. I'm a novice to powerquery but already kicking myself for not having found it earlier.

TIA

 

[horseyride]

Give an example of data input and desired output