cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
cphi Frequent Visitor
Frequent Visitor

Two weighted average columns based on different measures in a row

Hi, I need to create two different weighted average columns based on different measures in a row.

 

Sample data:

NameMeasure 1Measure 2Measure 3Measure 4Measure 5Measure 6Measure 7
Project 11432151
Project 22545412
Project 33211224

 

Weighted average column one: measure 1, 2 & 3  for the respective project in that row 
Weighted avergae column two: measure 4, 5, 6 & 7 for the respective project in that row 

Is this something that can be done in Power BI?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Two weighted average columns based on different measures in a row

Hi,

 

Try this

 

WA 1 = ([Measure 1]+[Measure 2]+[Measure 3])/3

3 REPLIES 3
Super User
Super User

Re: Two weighted average columns based on different measures in a row

Hi,

 

How should the weighted average be calculated and what answer are you expecting in each row?  What do those measures actually calculate?

cphi Frequent Visitor
Frequent Visitor

Re: Two weighted average columns based on different measures in a row

Hi,

bi.PNG

WA1 would be calculated for Project 1 by: (1+4+3)/3 = 2.6666

WA1 would be calculated for Project 2 by: (2+5+4)/3 = 3.6666

WA2 would be calculated for Project 1 by: (2+1+5+1)/4 = 2.25

WA2 would be calculated for Project 2 by: (5+4+1+2)/4 = 3

 

Super User
Super User

Re: Two weighted average columns based on different measures in a row

Hi,

 

Try this

 

WA 1 = ([Measure 1]+[Measure 2]+[Measure 3])/3