Forum Discussion
Average per month
Hi,
I have below set of data and would like to calculate the average Inventory Qty per month. On certain month, there is no inventory but that month need to be considered as well.
Measure for average per month = (5+1+4+3+...+10)/12 months
Thanks!
limxx1 I just provided a similar solution to this post. Re: Average measure not working - Microsoft Power BI Community
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) 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!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
1 Reply
limxx1 I just provided a similar solution to this post. Re: Average measure not working - Microsoft Power BI Community
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) 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!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡