topic Re: Backlog Data in Developer

Backlog Data

ghouse_peer — Thu, 21 Apr 2022 06:20:23 GMT

Hi Team,

I have a table in which we have 4 columns named Ticket Number,Opened Date, Closed Date, State

Ticket Number: Unique and may have different states based open Open and close.

Opened Date: Contains all dates of past 2 years to till date.

Closed Date: Contains all Dates from past 2 years to till date.

Stae: Open and Closed

Question is i need backlog count and calculation is in this way: (Opened Ticket Count of current Month)-(Closed Ticket of Current Month)+ (Opened tickets of Previous months which are not closed in any months and is still open)

PLease help me with the solution

Re: Backlog Data

amitchandak — Fri, 22 Apr 2022 10:27:13 GMT

@ghouse_peer , refer if this can help. or files can help

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

Re: Backlog Data

ghouse_peer — Sat, 23 Apr 2022 05:37:42 GMT

HI @amitchandak

Tried your calculation/DAX and referred to files attached, i am getting solution, but the count is wrong and difference of current Month(Open-closed)+ diff of previous month = Backlog count. This count i am unable to get it. Kindly help

For ex: lets say earlier to March month Backlog was 100 after all calculations.

Now

March: Open =250; Closed=180; Diff=(250-180)=70; Backlog 70+100=170

April: Open=410; Closed=315; Diff=(410-315)=95; Backlog 95+170=265

This Backlog count i need, PLease help

Re: Backlog Data

amitchandak — Sat, 23 Apr 2022 05:59:35 GMT

@ghouse_peer, Please find attached file, you might need a small change

Re: Backlog Data

ghouse_peer — Tue, 26 Apr 2022 08:03:15 GMT

HI Amit

This gave me only difference of count which was almost near but couldnt find previous month backlog.

Accepting this as solution because same question has been raised in detail in other board in Desktop category. please provide solution in that.

Thanks for the support.