cancel
Showing results for
Did you mean:
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
Resolver I

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'))``

Resolver I

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'))``

Announcements

#### Calling all User Group Leaders!

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

#### Community & How To Videos

Check out the new Power Platform Community Connections gallery!

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