Forum Discussion
Post PatronBacklog Data
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
ghouse_peer, Please find attached file, you might need a small change
4 Replies
- amitchandak
Super User
ghouse_peer , refer if this can help. or files can help
ghouse_peerHI 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
ghouse_peer, Please find attached file, you might need a small change