Skip to main content

    Power BI

    New

    Weighted Average

    Vote (80) Share
    Joel's profile image

    Joel on 14 Apr 2016 01:11:55

    It would be great if there was a way to create a weighted average. For example, if you have units and prices which vary, it would be great to have a quick and easy way to create a weighted average price when you slice the data. It would basically be a sumproduct of the units and prices divided by the sum of the products.

    Comments (4)
    Joel's profile image Profile Picture

    a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 22:49:31

    RE: Weighted Average

    You can already do this with simple DAX statements. Similarly to the idea of SUMPRODUCT in Excel, you can use SUMX([col1]*[col-weights])/sum[col-weights]

    Joel's profile image Profile Picture

    dc564081 32bd-459e-9a3e-37ff29abb580 on 05 Jul 2020 22:47:50

    RE: Weighted Average

    Weighted average interest rate would be great for us. You would need to be able to specify what you were weighting by (eg face value or market value).

    Joel's profile image Profile Picture

    2bc6a9a5 2ced-49ae-a062-380f30b77058 on 05 Jul 2020 22:44:19

    RE: Weighted Average

    Also could do with other ttpes of trend line such as Power Exponential etc

    Joel's profile image Profile Picture

    0a95c25a 29e1-4da5-a0c6-bc5db36f21ca on 05 Jul 2020 22:33:05

    RE: Weighted Average

    Having a weight column would be a great addition.