Answered

Find the average of a date range?

(1) Share

Report

Posted on by DMSC

Hi all,

Admittedly, math is not my strongest. Quick question, if I use the created date and also capture and end date of a request (via SP list), is it possible to show the average time for date of completion for a choice column?

Does that make sense?

Thanks,

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Michael E. Gernaey 53,442 Super User 2025 Season 2 on at

Like (0)

Report

Hi

would it be ok to ask a clarifying question.

Why would you want a choice column full of date averages I only ask as maybe I am misunderstanding

Also, when you say calculate the average, you mean go through each row, get the average across all rows and display that? What would it do in a Choice?

Was this reply helpful? Yes No
DMSC 65 on at

Like (0)

Report

Hi FLMike

Completely understandable question.

It's more to show averages over request types (subject matter).

E.g.

Choice 1 - General request

Choice 2 - Legal request

Choice 3 - Risk and Compliance request

Certain areas want data on average 'time to complete' requests based on subject matter to easily identified effort required.

Does that make sense?

So I would like to ideally find the average time to complete based on request type (and then narrow it even further by month and also year).

DW

Was this reply helpful? Yes No
Verified answer

timl 36,411 Super User 2025 Season 2 on at

Like (0)

Report

Hi DMSC,

Yes, it's possible to do this.

If you take the source data and filter it by your choice column, you can call AddColumns to a column that calculates the difference between the created date and end date.

You can then call Sum to find the total difference across all rows and divide by the row count that's derived by calling CountRows.

The important thing to note is that because these functions are not delegable against SharePoint, the source data that's filtered by your choice value must not exceed 2000 rows. If the volume of data per choice exceeds 2000, the result will not be accurate.

Was this reply helpful? Yes No
DMSC 65 on at

Like (1)

Report

Thanks for pointing me in the right direction, timl,

Worked a treat.

DW

Was this reply helpful? Yes No
timl 36,411 Super User 2025 Season 2 on at

Like (0)

Report

You're welcome DW, glad to help!

Was this reply helpful? Yes No