I suggest you try making another query where you extract the data and aggregate it according to the average you need to calculate. Once you have your dataset, you can directly merge it with the first one you extracted. The commands for averaging and aggregation are directly available with LINQ.