Need help with burndown chart

[veyron]

All - Thank You for your help. I am not sure where to start to build out a burndown chart.

In ADO, I have 4 fields in a user story with which to build a burndown:

- Title

- server count

- migration date

- Retirement date

>50% of the titles don't have migration and/or retirement date.

Every title will have a server count value. 

Goal is to build a monthly burndown chart for the last 2 years, consolidating between migrating and retirement date and showing how many more servers are left to migrate/retire.

Sample data:

Title	Server Count	Migration date	Retirement date
Title 1	2	02/20/2019
Title 2	1
Title 3	2		03/10/2020
Title 4	3		05/15/2022
Title 5	2	01/25/2022

What I would like to see is:

Feb 2019 - 10 Servers

…

Mar 2020 - 8 Servers

..

Jan 2022 - 6 Servers

May 2022 - 4 Servers

Is this doable in PowerBI? Any help is really appreciated. Thanks!

V.