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