Resolved bugs per month - Azure DevOps

[florencia_bne]

I have three tables. History Table is an Azure DevOps Analytic View, with historical records for each bug. All Prod Bugs is a query. I created a calculated column, Resolved Date, which takes either Closed Date or a different date depending on specific criteria. 

So far, that works fine. By creating a relationship between both tables, I can get the Resolved Date for each bug in All Prod Bugs. The issue is when I try to run calculations using that data. 

For example, using different formulas, I was able to show on a chart how many bugs were opened in a month, how many were pending from the previous month (carry over), how many were closed, etc.

Here's my formula for closed bugs:

. Closed in Month =

CALCULATE(

DISTINCTCOUNT('All Prod Bugs'[Bug]),

USERELATIONSHIP(Dates[Date], 'All Prod Bugs'[Closed Date]),

'All Prod Bugs'[Closed Date] <> BLANK()

)

But I need to calculate the same thing using the Resolved Date in All Prod Bugs instead of the Closed Date. Unfortunately, my current formulas are producing incorrect numbers. Does anyone know how can I fix this?

[v-saisrao-msft]

Hi @florencia_bne,

Could you please confirm whether the issue has been resolved? If not, share the sample PBIX file

Thank you.

[v-saisrao-msft · Accepted solution]

Hi @florencia_bne,

Thank you @vojtechsima, for your insights.Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? 

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Thank you.

[vojtechsima]

Hey, @florencia_bne ,

I have a silly question, but did you try replacing the USERELATIONSHIP part with the Resolved Date instead of the Closed date? Or what exactly is not working? Perhaps you could model some same data and pass it to us?