Forum Discussion

ZuzanaK's avatar
ZuzanaK
Frequent Visitor
3 years ago

weighted average

Hello,

 

I am struggling to create weighted average as this case is sort of unusual. Essentially, most of the campaigns have multiple strategies where I want to create uplift weighted average across strategies for each campaign respectively. Once I have that I would like to create uplift weighted average across all campaigns per each month. 

 

Any suggestions?

Thanks,

Z

 

Campaign Id

Strategy Id

Month

Budget

Booked Uplift

63f5ebc348636621c86a4666

63f5ec3ef39e1f27e771b634

March

50000

23

63f5ebc348636621c86a4666

63f5ed4e48636621c86a46d

March

20000

0

63f5ebc348636621c86a4666

63f77076f39e1f27e771b6d

March

9000

2

63f5ebc348636621c86a4666

63ff45ffd9d5047da9f9ddde

March

3000

11

638646475ff14c20d5065344

6389daa20720a332eb340se

March

10000

4

638646475ff14c20d5065344

6389e202ad090878732f8cjg

March

9000

68

638646475ff14c20d5065344

6389e25bad090878732f8cje

March

64000

240

638646475ff14c20d5065344

6389f187ad090878732f8cjd

March

1000

48

 

 

Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago
    Weighted uplift = 
var a = SUMMARIZE(Campaigns,Campaigns[Campaign Id],"bd",sum(Campaigns[Budget]),"ul",sumx(Campaigns,Campaigns[Budget]*Campaigns[Booked Uplift]))
return sumx(a,[ul])/sumx(a,[bd])

    (you should use DIVIDE() to safeguard against division by zero)

    see attached.