Here is my defects dataset (raw data)
Each defect has created date , resolved date. Based on these 2 days i would like to calucalte the backlog trend by month
|Key||Defect Created||Defect Resolved||Current Status|
|B-77340||1/3/2022 0:00||3/28/2022 0:00||Resolved|
|B-36770||1/4/2022 0:00||5/12/2022 0:00||Resolved|
|B-37657||1/6/2022 0:00||1/11/2022 0:00||Resolved|
|B-77386||1/6/2022 0:00||1/13/2022 0:00||Resolved|
|B-37732||1/7/2022 0:00||2/11/2022 0:00||Resolved|
|T-77682||1/26/2022 0:00|| ||Open|
|I-11158||3/4/2022 0:00||5/12/2022 0:00||Resolved|
|N-11369||3/25/2022 0:00|| ||Open|
Backlog trend is calculated based on the Created and Resolved dates.
In the below graph Jan month as overall 6 defects and 2 defects were resolved. Hence there are 4 defects are backlog and it will carry forward for Feb month.
In Feb month 0 defects were created and 1 backlog (jan months defect) is Resolved. Hence we have 3 backlog defects.
Can we calculate this kind of backlogs through DAX ?