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
Go to Solution.
@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.⚡
Proud to be a Super User! Appreciate your Kudos 🙂 Feel free to email me with any of your BI needs.
View solution in original post
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!