Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Weighted Average

Hi I'm trying to calculate weighted average for some data I have. Below is sample of the data.    Product Month Stock Sold Stock/Sold Prod 1 JAN 5000 4800 1.041667 Prod 2 JAN 1...
Need Help
v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi, Anonymous ;

So what's your logic? If you want the output result to be only 3.28, then you can use the following formula.

Averge = AVERAGE('Table'[Stock/Sold])

the final show:

If the above one can't help you get the desired result, please provide your expected result with backend logic and special examples.  Thank you.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi v-yalanwu-msft 

    If you see the data above. Prod 2 has 10 in stock and 1 in sold. The ratio sold/stock is 10.

     

    So, if I want to find the average of all ratios, Prod 2 will make the average unrealistic because it's for only 10 items. While other products has thousands of items.

     

    So, if i'm to take average of Stock/Sold it would be 3.28 but the actual average (weighted average) should be close to 1.06.