Need help with balance calculation

I need some help figuring out how to fill out the rest of a table with projected balances. Here is my visualization:

I need to calculate what the blank values should be. The calculation would be LPCapitalAccount_Actuals for 2018 = LPCapitalAccount_Actuals for 2017 - LPLosses_Forecast for 2018 (and so on down the row).

Here is a link to my Power BI file: https://drive.google.com/open?id=1kdcojRqo9WohmPHiz4YyQb2S_W8K79NV

Sorry if there is another preferred format. As you can see in the data, my intent is to select a partnership ID and then calculate what the expected values would be for LPCapitalAccount_Actuals which are currently null.

Any advice?