Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Weighted Average - Arithmetic Mean

Good afternoon

We have been working for several weeks on being able to make a Weighted Average/Arithmetic to include it in a dashboard. The problem is that we only get the "normal" average and it is a puzzle. If anyone has the solution would be appreciated

If anyone knows the solution to add the weighted to add it to the "average leadtime" box.

Thank you

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Syndicate_Admin , Need a sample data for that.

     

    But

    divide(Sumx(Table, [Col1] * [col2]), Sumx(Table, [Col2]) )

     

    should help

     

    If this does not help
    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.