Forum Discussion
Solved
Average Calculation
Hi All, I have the below data, im just simply trying to do an average calulcation for each of the ID's that I have, normally I would have just put the "Amount" into the values field and used the ...
cosminc yeah. You can use the little down arrow there to change it to any other summarization type, such as average. Or of course write an explicit measure that does the same thing. Such as...
Avg Amount = AVERAGE(TableName[Amount])
This is fairly easy in the Query Editor. Go to the Transform tab and use the Group By button. Group by your ID column and use sum of Amount as the aggregation type.
That assumes you want a hard table with this aggregation pre-calculated. You can also do this in a report by either writing a measure that does an average of Amount, and just set that measure next to the ID column on your report page, or just drop the two columns side by side and set the aggregation on Amount to average, and ID to "do not summarize."