AnonymousNot applicable5 years agoSolvedAverage by column Hi Experts, How to calculate the average per a certain column for example, as per the below table end result should be (2+6+9)/3 ColumnA ColumnB X 2 X 2 ...Show MoreVahidDM5 years agoAnonymous try this: Average distinct = AVERAGEX (DISTINCT('Table'),[ColumnB]) Table : Output: Click here to see more details about DISTINCT. If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Appreciate your Kudos !!
VahidDM5 years agoAnonymous try this: Average distinct = AVERAGEX (DISTINCT('Table'),[ColumnB]) Table : Output: Click here to see more details about DISTINCT. If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Appreciate your Kudos !!
VahidDM5 years agoAnonymous try this: Average distinct = AVERAGEX (DISTINCT('Table'),[ColumnB]) Table : Output: Click here to see more details about DISTINCT. If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Appreciate your Kudos !!
Related contentWeekly AverageMatrix Average ColumnAverage and Moving AverageAverage columnAccumulated average
