Forum Discussion

Frequent Visitor

9 years ago

Solved

Average column

Hi, I have this table and I'd like to add a column similar to the total column but with the average. When I try do it, a column with the average appears also in each month. My questio...

Need Help

v-sihou-msft
9 years ago
dinomaster

In Power BI Desktop, we can change the aggregation type of the field into "Average". It will be applied onto Grand Total row/column as well.

But we can only keep on Total row/column in a visual. It's not supported to add one more "Grand Total" row/column manually.

Regards,