Forum Discussion
Hot to put Average by Month in Matrix Visualizations
Hi, I try to put in the Matrix Visualizations the Avegare by month, but the result is wrong.
How to make that average if i need to choice Year an dmonth (maked yellow)?, thanks a lot by the help
Hey Anonymous ,
if you are looking for creating explicit measures than this article is a good start: Power BI Aggregate Functions | Guide to use Aggregate Functions (wallstreetmojo.com)
More simple, but of course with its own downsides, is using the build-in aggregation functions, that create implicit measures; Work with aggregates (sum, average, and so on) in the Power BI service - Power BI | Microsoft Docs
Hopefully, this provides some ideas on how to tackle your challenge.
Regards,
Tom
7 Replies
- TomMartens
Super User
Hey Anonymous ,
if you are looking for creating explicit measures than this article is a good start: Power BI Aggregate Functions | Guide to use Aggregate Functions (wallstreetmojo.com)
More simple, but of course with its own downsides, is using the build-in aggregation functions, that create implicit measures; Work with aggregates (sum, average, and so on) in the Power BI service - Power BI | Microsoft Docs
Hopefully, this provides some ideas on how to tackle your challenge.
Regards,
Tom
- v-xulin-mstf
Community Support
Hi Anonymous
Is this measure what you want?
Averagex(filter(all'table',month('table'[Date])=month(max('table'[Date]))),'table'[value])Here is the output:
If you still have some question, please provide your expected output and data structure.
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
- v-xulin-mstf
Hi Anonymous,
Is your issue solved?
Without the data structure, maybe the measure does not work.You can refer the AVERAGEX function.
You can also provide your data structure or pbix after removing sensitive information, i will check it in my environment.
If you still have some question, please don't hesitate to let me known.
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
