Calculate estimated finish date in Azure Devops based on remaining story points and current velocit

In Azure devops, I have:

• user stories with effort estimates
• an average velocity based on the last sprint.

I want to calculate the estimated finish date and display it in a dashboard in Azure Devops. Is this possible?

Basically I want the following calculation to update automatically in my dashboard:

1. Estimated remaining sprints = SUM(story points of stories with status new) / average velocity
2. Estimated finish date = today + Estimated remaining sprints * sprint length

I am afraid that there is no built-in/extension chart or Dashboard Widget can calculate the estimated finish date as your requirement.

Azure DevOps doesn't support displaying chart data based on custom calculations for the time being.

In order to obtain the calculation results, you need to export the data in Boards to Excel or PowerBI for further calculation. But they cannot be displayed in the Azure DevOps Dashboard.

I can fully understand your requirement. You can submit a suggest ticket in the site: Developer Community to report this feature.