Forum Discussion
Calculate Weighted Average
I tried this formulae to calculate weighted average- W_Average = SUMX(Table1,[quantity]*[Price])/SUMX(Table1,[quantity]) But it is giving me wrong data, I don't know why? Can you guys please...
Hi Anonymous
Based on my research, there are some samples how to calculate weighted average in power bi.
https://community.powerbi.com/t5/Desktop/Weighed-Average-DAX-Expression/td-p/112496
If you have any problem, please share some example data or tell what's wrong and what's expected.
Best Regards
Maggie
Hi Anonymous
Based on my research, there are some samples how to calculate weighted average in power bi.
https://community.powerbi.com/t5/Desktop/Weighed-Average-DAX-Expression/td-p/112496
If you have any problem, please share some example data or tell what's wrong and what's expected.
Best Regards
Maggie