Weighted Average of Weighted Averages

[davidcas77]

Hello,

I have a question for Powerpivot, DAX.

Let's say that we have a list of energy productions of different generators (different KW power) by day, spanning to a full year.


In the first step, we calculate the weighted average of each month, according<gs id="e3bac332-103d-4e32-80b2-09d43cee2851" ginger_software_uiphraseguid="67dffe00-1abf-4d0b-bb2c-9d363815036f" class="GINGER_SOFTWARE_mark"> to generator wattage.</gs> This is easy.

What I cannot resolve is how I can calculate the Quarterly/Semester/Yearly weighted average, based on the weighted averages of each month (3/6/12 averages calculated in the first step), according to each month's total production.

Any thoughts?

<gs id="c3d3902b-f783-46fb-b077-7ca88807eb0b" ginger_software_uiphraseguid="c14f4179-1d22-416e-aa48-31419c82ed29" class="GINGER_SOFTWARE_mark">Thanx</gs>


David

 

[ImkeF]

Hi David,
not sure what the difference between your monthly averages and the following ones actually is.
If you have a DimDate-Table that also has Qtr/Sem/Year in columns, why not just use your existing Avg measure? Doesn’t it produce the weightage you actually need on those fields as well?

 

[davidcas77]

</gs>Hi David,
<gs id="276b220b-d06b-4d3d-ac13-da0e30bc4760" ginger_software_uiphraseguid="19c470a3-5829-41cc-be5e-ff48f7316d9e" class="GINGER_SOFTWARE_mark">not</gs> sure what the difference between your monthly averages and the following ones actually is.
If you have a DimDate-Table that also has Qtr/Sem/Year in columns, why not just use your existing Avg measure? Doesn’t it produce the <gs id="86295e8a-1143-4f18-adb0-0d87a3d81c79" ginger_software_uiphraseguid="e7892d46-910b-48de-9938-273f416e59d3" class="GINGER_SOFTWARE_mark">weightage</gs> you actually need <gs id="b85d3327-75e6-4b7a-b1cb-e50068ad9017" ginger_software_uiphraseguid="e7892d46-910b-48de-9938-273f416e59d3" class="GINGER_SOFTWARE_mark">on</gs> those fields as well<gs id="a4b0ddfd-7b2c-4212-8dd6-cf4a6d0e37b5" ginger_software_uiphraseguid="e7892d46-910b-48de-9938-273f416e59d3" class="GINGER_SOFTWARE_mark">?</gs>

I thought that the result will be different between using the <gs id="5f1154f1-f164-428a-a5e6-50ef2472c78f" ginger_software_uiphraseguid="a0bafffd-b2fc-4ff2-b11b-437a1ec233fb" class="GINGER_SOFTWARE_mark">qtr</gs>/<gs id="92339120-95f7-42b5-bb04-7fbd76b2a502" ginger_software_uiphraseguid="a0bafffd-b2fc-4ff2-b11b-437a1ec233fb" class="GINGER_SOFTWARE_mark">sem</gs> from <gs id="b359d0f6-ba56-4bc6-9461-7447263efeac" ginger_software_uiphraseguid="a0bafffd-b2fc-4ff2-b11b-437a1ec233fb" class="GINGER_SOFTWARE_mark">dimdate</gs> table and by getting the weighted average of the result of each month. Apparently they are the same.

Thank you

Davie