I need to create completed date for jira issues

[Prabha0673]

I need to create completed date for jira issues , like how many issues are completed, howmany in backlogs like that I want so how can I go,, 

[Idrissshatila]

Hello @Prabha0673 ,

can you provide a sample data and the expected output. Also what's the formula that would make the issue completed and on how many in backlog.

[Prabha0673]

Actually I have two tables data one is measures with older version and another one is with new measures for jira issues, so here I don't have created date in new table but old table we have, so here I need to create for completed like resolution date I need to create,,, with that I need to show the values with in the period how many resolved, howmany tickets backlog, like wise I need to show

[v-jialongy-msft]

Hi @Prabha0673 

Please provide detailed sample pbix file and the results you expect.So that I can help you better. Please remove any sensitive data in advance.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.