Daily trend with backlog showing

[72_tam]

I need help with a formula - please!...I have a line chart that shows a backlog of work orders...I'd like to show the total # of backlog orders since beginning but limit it to a daily trend of last 2 years.  My data goes back to 2015.

For my running backlog, I used:

Running Total by Day =CALCULATE( [Difference], FILTER( ALLSELECTED(Append1[Date]), ISONORAFTER(Append1[Date], MAX(Append1[Date]), DESC)

[lbendlin]

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-...

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/1447...

[72_tam]

Having a hard time entering the data as a table, sorry!  This is my dataset...not all data is here as I had to enter it manually but I have dates, created work orders, completed work orders and a running total by day.  I'd like to show this as a daily trend capturing the last 2 years of daily activities but limit it to two years and not back to 2015 as seen in data below. 

Date		Created		Completed		Running Total by Day
2015/04/14		1				1
2016/12/15		1				2
2018/12/20		1				3
2020/02/21		5				8
2021/01/19		2				10
2021/03/26		3				13
2021/03/29		1				14
2021/07/29		1				15
2021/08/10		1				16

[lbendlin]

You can solve that in two ways

Easy way: use zoom sliders

Hard way:  Calculate running total before the selected time range plus running total in the selected time range