calculate

[prashantg364]

Hi,

For any given date range, I am having a table shown below.

Now I want to calculate how many weeks are required with the same workers to clear the backlog and inflow (considering the Average weekly inflow will add for the coming weeks).

Output example: So I will need the next 2 weeks to take my productivity positive.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523