Forum Discussion
How to find average on matrix?
I've built out a matrix from a PBI dataset given to me, and I'm currently trying to build out an average column. Each column provides a month with x amount of count values in each row. Is there ...
parry2k
Super User
Super UserTummi assuming the month is from the calendar dimension, add the following measure:
Avg = AVERAGEX ( VALUES ( Calendar[Month] ), [Extended Price] )
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!