Creating metric from multiple field that updates on a regular schedule

Hi Shadd307 ，

I am not sure if I understood your question correctly. Do you have up to 6 sprint period per team in your data? Then you need to calculate the average number of issues completed in those periods. If so, please create the new table.

Table 2 = 
SUMMARIZE (
    'Table',
    'Table'[team_name],
    "Velocity",
        DIVIDE (
            CALCULATE (
                COUNT ( 'Table'[issues ID] ),
                'Table'[completed before sprint end] = "Complete"
            ),
            DISTINCTCOUNT ( 'Table'[sprint.sequence] )
        )
)

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.