Forum Discussion

ghouse_peer's avatar
ghouse_peer
Icon for Post Patron rankPost Patron
4 years ago

Count of Backlog 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. Opene...
Need Help
ghouse_peer's avatar
ghouse_peer
Icon for Post Patron rankPost Patron
4 years ago

Hi Amit Chandak,

 

 Thanks for the files for reference.

 

 Tried your calculation/DAX, 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