Count of Backlog data

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

Hi amitchandak 

Thanks for the input and files

 Tried your calculation/DAX and referred to the files and tried, 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