Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 help me how to calculate weighted average?

 

Thanks in Advance

Need Help

3 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous can you share sample data and what you think is not working?

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous , seem like correct formula. Can you share sample data and sample output in a table format? Or a sample pbix after removing sensitive data.

    Try this in between : W_Average = divide(SUMX(Table1,[quantity]*[Price]),SUMX(Table1,[quantity])*1.0)