Announcements
Hello Everyone,
I happen to have a list that has a few columns with records added on daily bases. Now I need to show the Month Till date average of these columns in my app. Please help how can I get this done?
Here is an example of how my list looks like. I would like to get the average of all values in 'Score' column based on month where it is july.
Hi @ashar1990 ,
You can do so by using a combination of the Filter and Average functions. The Filter function is used to select the items for MTD and the Average function then calculates the average:
Average( Filter( 'Dummy List', Month = "July", ), Score% )
The filter condition is hard coded in the above example, but can be replaced with a reference to a dropdown or the current month.
To get the average for july, you could try something like:
Average(Filter(*YourList*, Month = "July"), Score%)
Hope this helps!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 429 Most Valuable Professional
11manish 191 Super User 2026 Season 2
MS.Ragavendar 122 Super User 2026 Season 2
