create graph from daily data of dataset

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

@lbendlin 

Graph 1: number of work items committed accepted (closed state) / (number of work items planned (closed state need to exlcuded)) e.g: 5/14*100 = 35.71 (only first 5 items are closed and rest of them are newly added)

(14 only items present on 25 Oct which are in not closed state, exclude close state for count) ref sheet 4

Graph 2: number of work items committed accepted (closed state) / (number of work items planned - number of committed work  items explicitly removed) 

Graph 3: number of work items added / number of committed work items e.g: 9/14 = 64.28

below is example of Q3 S1: start date on 25th Oct and end date on 7th Nov

google link:

https://docs.google.com/spreadsheets/d/1NkFs-BnPTnqacRuEtYg5BoSwPOgSzk3n/edit?usp=drive_link&ouid=11...

What is the significance of the [Date] column in the RRR table?

in RRR Table, Date reflects the workitem status on that particular day and would have all calender days for a durtion.

Currenly pulling report of all workitem status on each day for a specific duration, so that we know the historcal infomration of work items on that particalur day for creating graphs.

That seems excessive. Have you considered using change tracking instead?