Backlog Data

[ghouse_peer]

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

[amitchandak]

@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-tr...

[ghouse_peer]

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

[amitchandak · Accepted solution]

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

[ghouse_peer]

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.