Forum Discussion
Post PatronCount of Backlog data
Community Championhey ghouse_peer I just solved something very similar to that in a differnet question.
https://community.powerbi.com/t5/Desktop/End-of-month-backlog/m-p/2469889#M880720
Post PatronHi Sparta,
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
- amitchandak
Super User
ghouse_peer , Please find attached file, you might need a small change
- ghouse_peer
Hi amitchandak
Thanks for the solution
I tried your measure which you showed in your file. It returns only difference and count is high in case of my data.
Please check this Detailed version of my question and scenario this would help you to generate solution.
our expected output is :
This line and clustered column chart represents count of state(open,Closed) w.r.t months. I need to get line graph(line Yaxis)of backlog.
I have 2 tables for this.
Table name: Data
Ticket Number Opened Date Closed Date State Table Name: Calender
Relationship: 1 to Many [Date to Opened date: Unidirectional Active]
1 to Many[ Date to Closed Date: Unidirectional Inactive]
1 to many [ Date to State : Unidirectional Inactive]
Calculation for Backlog [Line Y axis]: count of (Open-Closed+Previous Backlog) i,ePrevious backlog in the sense open-Closed of previous month and so on.
Let us Assume Dec month Backlog was 250. in Jan 22 we got Open:300 Closed 210 so backlog will be (300-210)+250=340. This should be shown in line Yaxis in chart for Jan month.
Kindly help with any other alternative to get the solution.
