cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Usernametwice23
Helper V
Helper V

Help with a formula

Hey all 

 

I just need some help with this formula. I am trying to get the average of 3 different columns in a data table. 

 

Here is the formula and credit at @WarrenBelz for helping me put it together - 

"Average = " & 
With(
   {
      wList:
      Filter(
         'Daily Measurement', 
         'Daily Measurement(Views)'.'Active Daily  Measurement',
         'Count'.'Counts'=GalleryList.Selected.'Count'.'Counts'
      )
   },
       Average(
         wList,  
    '1 Count Column', '2 Counts Column', '3 Counts Column')
)

 

This part here is giving me the trouble - 

Average(
wList,
'1 Count Column', '2 Counts Column', '3 Counts Column')
)

 

It doesnt let me use multiple columns in this case. How can I make it so that I can use all 3 columns and get the average of all 3 instead of just 1 column?  

 

Thank you and kind regards. 

1 ACCEPTED SOLUTION

Accepted Solutions
lcimon
Resolver I
Resolver I

Hello @Usernametwice23,

Average function can't be used with multiples columns of a collection. A workaround would be to calculate the average line by line and then the average of line average, like this:

Average(wList, Average('1 Count Column', '2 Counts Column', '3 Counts Column'))

 

View solution in original post

1 REPLY 1
lcimon
Resolver I
Resolver I

Hello @Usernametwice23,

Average function can't be used with multiples columns of a collection. A workaround would be to calculate the average line by line and then the average of line average, like this:

Average(wList, Average('1 Count Column', '2 Counts Column', '3 Counts Column'))

 

View solution in original post

Helpful resources

Announcements
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,458)