Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Gameplayer13905
Frequent Visitor

How to add an average to a matrix without using a measure - I've seen it but can't find it now

Hello all and thanks in advance. A coworker showed me the other day how to add an average to a matrix or table and now I can't find it. She right clicked on something and a column of choices appeared which showed Sum, Average, etc. Anyone remember where this is?

 

Thanks again

1 ACCEPTED SOLUTION
vicky_
Super User
Super User

vicky__0-1699924429488.png

It's on the Right hand side where you put the data. However, you won't be able to see it if you're trying to get the average of a measure - it will only show up if you use a numeric type column

vicky__2-1699924560109.png

View solution in original post

2 REPLIES 2
vicky_
Super User
Super User

vicky__0-1699924429488.png

It's on the Right hand side where you put the data. However, you won't be able to see it if you're trying to get the average of a measure - it will only show up if you use a numeric type column

vicky__2-1699924560109.png

Thank you Vicky_, will this work across a series of months? I have a table with columns like this

Jun_23

Jul_23

Aug_23

Sep_23

I am trying to get an average of the four months for each customer. I think what you showed, and it is what my coworker showed me, thank you! - it's the average for all of the data in a given month. Can you give me your thoughts? I'll mark this as solved shortly

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.