Projecting from known starting and ending values

[jdonkers]

Dear Power BI Community,

I have the table below where I need to show for each site the emissions decreasing until it hit 0 by the "Net Zero Goal" column year within the duration indicated in the far right column. If the start year is 2023, all site except for E will hit 0 before its target year. 

Site	Current Emissions Value	Net Zero Goal	Project ed Savings Duration
A	835.75	2030	5
B	667	2050	25
C	932	2050	25
D	932	2050	25
E	504	2045	25
F	958	2050	25
G	1020	2050	25
H	771	2050	25
I	771	2050	25
J	1382	2050	25
K	1500	2050	25

I am having difficulty with creating a table that PBI can understand. I created the table below in excel and that worked but I'd like to be able to create this within PBI as the starting/current year could change depending on when the client wants to start their emissions savings. I created the table below for each site and appended them into one table and that worked. Like I previous stated, doing this in excel doesn't allow for me to adjust the starting year.

Time	Emissions	Site ID
2023	835.75	A
2028	238.7857	A
2025.5	537.2679	A
2030	0	A

I have tried to convert everything to dates using the following formalas 

• datedif (excel), datediff (PBI)
• edate

However, I ran into the following issues:

1. Could not format a working table that PBI can make into a line chart
2. I could not create a numeric range parameter for the projected start date

One thing to note is that the project start date should align with the current emissions column from the first column. Such that if site A were to start in 2027, they would have 3 years to complete their emissions savings to reach the 2030 year target. 

The idea is to have several line charts that depict the emissions decreases for each site and being able to adjust the start year like below.

Thanks in advance. Let me know if I can clarify something else!