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 = " &
'Daily Measurement(Views)'.'Active Daily Measurement',
'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.
Go to Solution.
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
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Check out the new Power Platform Community Connections gallery!