Forum Discussion
Solved
Weighted averages in Power Query
Hi, I have a set of data as follow. LocalString Units Value Sum America 25 10 250 Australia 3 50 150 America 89 20 1780 And so on. Before, I would group and ta...
The code below should do the trick. Just adapt your List.Average to List.Sum([Sum])/List.Sum([Units]).
= Table.Group(Source, {"LocalString"}, {{"Sum", each List.Sum([Sum])/List.Sum([Units]), type number}})
The code below should do the trick. Just adapt your List.Average to List.Sum([Sum])/List.Sum([Units]).
= Table.Group(Source, {"LocalString"}, {{"Sum", each List.Sum([Sum])/List.Sum([Units]), type number}})
Anonymous Thanks, that worked perfectly !
